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 Excel .
#padtext #excel #concat #replace #left #right #rept.
Keep Watching,Keep Learning.