Sir main ISI prakar ki tric ki Khoj mein tha bahut bahut dhanyvad iske liye

i have searching for while and never seen as quick as simple you show, for that you have earned my subscribe and like hhh, anyway thank you very much

How to extract mobile no from each row and copy to the last cell in that row.

Very Nice I am searching the same

if have applied this function to check for duplicate and text charactor no > 30 =AND(LEN(a2)

@deepakbhanushali1

4 жыл бұрын

I got the formula actually removed inbetween AND Function and there it is

for North America thinking we use 123 456 7869 right-click, format cells, and number custom formatting works awesome. BUT how do I protect just his format for this cell so that my team does not use copy and paste and wipe out formatting? I want to protect data format but not lock out field for input

@Excelrush

2 жыл бұрын

kzread.info/dash/bejne/gY5ryLBvmJbWgto.html This video has all that you're looking for :-)

What if the first digit is a 0? what do you have to do? apperently when i put 0 in the beginning, it does not count as a digit.

@Excelrush

6 жыл бұрын

while entering the number that starts with a 0, put a ' first. Example, '0123456789. It will accept it. if you like this solution, do subscribe to the channel!

@simonkirkebyrasmussen6124

4 жыл бұрын

@@Excelrush That does not work, since it then treats the input as text. Do you have a work-around where you can input a 0 (zero) as the first digit?

@Excelrush

4 жыл бұрын

No, there's no other way that I know of.

@simonkirkebyrasmussen6124

4 жыл бұрын

ok, thank you

thnks alot

@Excelrush

5 жыл бұрын

Do subscribe to the channel for more such tips!

hi sir i love your videos. i have a question how to to alphabet and number total fixe by 20 nos only accept how to to

@Excelrush

Жыл бұрын

Data tab - Data validation - text length, less than equal to 20

@sathishsunshine

Жыл бұрын

@@Excelrush this the example OD126544195465659000 two text and 18 number this type should be validate as to be good. not gose extra not less than. please tell me

hey, i have special conditions for column in google sheets which are: - should only be filled with numbers - no special characters allowed - no alphabets allowed - no space allowed - should be 16 digits in total i tried using =AND(LEN(A2)=16,INT(A2)=A2) which works in excel, but strangely not in google sheets. oh i also notice that the 16th digits always change into 0 in excel. can you please help?

@Excelrush

3 жыл бұрын

In data validation, use the formula =isnumber

@mommypowerrr

3 жыл бұрын

so it should be =AND(LEN(A2)=16,ISNUMBER)?

@Excelrush

3 жыл бұрын

=and (len(A2)=16,isnumber(A2))

@mommypowerrr

3 жыл бұрын

the output change into 1.23457E+15

@Excelrush

3 жыл бұрын

Make the format of the cells as NUMBER instead of GENERAL

It's work in Google sheets?

@Excelrush

3 жыл бұрын

Yes, it will work in Google sheets

@parthvaghela7389

3 жыл бұрын

Sir i need atomatic capital latter on first latter of word whan i type word i need to know aa formula for thet in Google sheets...

How to Avoid Duplication Number ?

@rashedict4592

6 күн бұрын

Please Add countif

i forgot my number i know the last two digit ********82 how to find 1st eight number

@Excelrush

4 жыл бұрын

Hi Kunal, I didn't quite understand the question, can you please elaborate more?

@kunalbajaj3547

4 жыл бұрын

@@Excelrush i forgot the number 1st eight digit how to find this is Aircel number & aircel company already shutdown the number is ********82 and ********42 i have two number 42 is the aircel number 82 i dont know please help me

@kunalbajaj3547

4 жыл бұрын

@@Excelrush hii please help me ********42 this is Aircel number but this Aircel company is shut down what to do please help me