How to pad text in Excel | Do you know how to pad text in excel

In this video, i will show you how to pad text in excel. This is one of the most pressing problems that people will come across while data cleaning.
I have used text formula to pad the unequal length of record to equal length of record.
Identify the max length of the array using len(max(a1:a9).let us say the max length from the array is 6
Then use a text formula =text(a2,"000000").
Post then i have used replace,concat,rept,right,left to mask number.
To know more about masking number , please follow this link.
• How to Mask Numbers in... .
#padtext #excel #concat #replace #left #right #rept.
Keep Watching,Keep Learning.

[@yangsmith5805]

I have not seen anyone explaining left padding in Excel. This is super helpful! I'm a big fan. 🤩🤩

[@BeboRT]

Woww, it's very interesting, liked it and enjoyed the video, Thank you Madam 👏👏👏👏👍👍👍

[@karpagamexcelprime]

So nice of you. My pleasure Aarti🙂

[@harshupadhyay6824]

Soo useful ma'am.

[@karpagamexcelprime]

Glad it was helpful Harsh 🙏

[@abhirupamaiti2952]

Amazing Ma'am 👌

[@karpagamexcelprime]

Thank you! Cheers!🙂 Abhirupa

[@shivashankar5220]

Amazing explanation. Loved it. I have never learnt these many formulas in such short span of time. Keep it rolling

[@karpagamexcelprime]

Thanks, will do!

[@RaviSingh-xl7re]

Really impressive way of teaching!!

[@karpagamexcelprime]

Glad you think so! Thanks Ravi👍

[@debadattadas8283]

Nicely explained. Thank you Professor

[@karpagamexcelprime]

Thank you sir

[@sivakalai3489]

How to mask mid of the string using concat?

[@karpagamexcelprime]

Imagine your text is in A2 which consist of 11 digits,similar to this 00112233445. Use this formula
=concat(left(A2,4),"***',right(A2,4)).
Which will get the answer as 0011***3445 .
Hope this would have solved your query 🙂

[@yourguide2352]

Example: "Train (11005)". How to extract only numbers 11005 from the given string

[@karpagamexcelprime]

Use right function :
In this case Train(11005). The number of character for 11005 is 5 . Imagine the text is in A2. Use this formula. =right(A2,5). This will extract the 5 digits.
Hope this would have solved the query 🙂

[@yourguide2352]

@@karpagamexcelprime Thank you madam. But it gives output as "1005)". Can u help me in getting the output as "11005"

[@karpagamexcelprime]

Hi Arun, i have made a video on the same. please follow this link to extract the text within the parentheses.
th-cam.com/video/SVh4U8gskYg/w-d-xo.html

[@yourguide2352]

@@karpagamexcelprime Thank you madam for your great effort.