Making life easy as always!

Your the best this is exactly what I needed thanks again

Great work but i have a question how to select sort data with length option

Thank you. It was very helpful.

Thank you 🙏🏻 it was very helpful

This very helpful 👏👏👏 thank you so much 🎉

very helpful, thank you so much sir

Wao. Exactly what I was looking for.

Hi Thanks for your great support i stucked up with 65000 mobile number to clean and make it ready clean data applied this formula and clean up the data and i got the data what i need Great work thanks for teaching :)

@Excelrush

4 жыл бұрын

Do subscribe to the channel!

Thank you very useful ❤️👍🏻

Thanks for sharing. Helpful for me

What a Clear explanation. Thanks

Very helpful!!!! Tanks!!!!

Great Video.....very niche topic...and i needed it....keeep up the great work

@Excelrush

6 жыл бұрын

Thank you! Do subscribe to the channel!

You have my respect

Very informative sir super

very good informative video

Thank you very much

Thank you so much sir

Grateful to you, Thanks

very nice thank you

THANKS VERY GOOD VIDEO

Thank you sir 🙏

Thanks help me alot save my so much time

Useful !!

Thank you

Thnk u so mch for ur video this video do my work too easy thnx alot i always edit 91 individualy

thanks a lot.

Thanks for making this vedio

Seems helpful

thanks bro

Thanks bro

thank you

well explained

Love you sir

Thanks

Thanku

thanks

thaks super timing help

@Excelrush

6 жыл бұрын

Welcome! Do subscribe to the channel..

Love From Pakistan. Thank you so much bhai...Like done. subscribe done

Tnks bhai

Superb

Nice

How to filter landline and mobile number separately as both are 10 digits

How i do same in. Google sheet

how can separate date into district

thank you right()

what if in the same column we have landline and mobile number (Mixed) then how we separate it can you tell me?

@hannabeprakash

7 ай бұрын

when you sort, you will see country codes with a + followed by STD codes and then 8 digit landline number. You need to see Wikipedia for the list of "Indian Valid Mobile Numbers" in google and then make a function with all necessary formulas in Excel to remove the characters, invalid mobile numbers, sort the numbers. Then you can easily see mobile numbers and landline numbers.

WOWWWWW

Understanding the problem, We need the SQL which will update the PC Score (Substract by 5 in this case) where the contact numbers are invalid, invalid contact numbers being: 1.value that is not 10 digit long number 2.does not start with '7' or '8' o

@sunilt.r988

Жыл бұрын

Can someone ans me this

How did you copy the formula down? I'm trying my hardest to figure that out

@Excelrush

5 жыл бұрын

Simple hold the bottom right part of the cell and pull it down

@SkySoushi

5 жыл бұрын

Or 1. move the mouse to the bottom-right corner of the cell with your formula, till the cursor changes to a black cross. 2. Double-click to auto-fill down as long as there are values in the column immediately to the left

@ashiqulameen7483

3 жыл бұрын

@@Excelrush sir could you please send your contact number . Please. I want your small help please

@ashiqulameen7483

3 жыл бұрын

@@Excelrush please sir i need your help

j india k liye chlega agr hor country b hui or uska country code b sath mai hua to exapnd kaise krege

@Excelrush

2 жыл бұрын

Toh phir alag alag karna hoga. Country-wise, ek ke baad ek country.

sir mobile number ke aage contry code 91 lagana hai forfulla batao plzz

@Excelrush

5 жыл бұрын

=concatenate("91",cell)*1

Shows a number in exel but it must be a different number. What a way??

Help me with video

if have to add 0 in beginning so how it would be added?

@Excelrush

2 жыл бұрын

Use the Concat function and '

Random mobile number कैसे select krege

@Excelrush

5 жыл бұрын

Use =Randbetween

12 digit ko bina + signke kaise insert kare

@Excelrush

6 жыл бұрын

Hi Ramesh, you can enter the 12 digit numbers (or even longer than 12 digits), then select all numbers and from Format Cells, convert them to 'Number' format. This will give you a corrent output. You can reduce the decimal points to 0 decimals if required

@DesaiRamesh

6 жыл бұрын

Excel Rush .com Thanks

How to add +91 for every number?

@Excelrush

2 жыл бұрын

Use =concatenate function for this

Mobile number text kavadam leydu

Sir mujhe 1000 contact no. Me agr 500 unwanted mobile no.(they are real no.)Ik saath delete krna ho to kya kru

@durlabhkashyap1432

Жыл бұрын

Help me sir

@Excelrush

Жыл бұрын

Just select all those 500 numbers together and press Delete

@Excelrush

Жыл бұрын

If I've understood your question wrong, pls let me know

Bro thank you so much I do support you and even gave you likes, However, please next time jump directly to the topic, no need to clean data and stuff you could have done that before you start this way your audience won't get bored and leave before they reach the point

can't we just change the alignment bro?

@Excelrush

3 жыл бұрын

Incase the data format is wrong, the alignment won't solve it.

Need unlimited USA Number data

Hindi me bolo

VERY GOOD ,REALY GREAT,HOW TO SOLVE THIS PROBLEM 6.68177E+14

This very helpful 👏👏👏 thank you so much 🎉

Thank you

Thanks

thanks

Nice