formula to standarize cell length

J

JT

I have a spread sheet with data in Column A. Some of the cells have 3
characters, some have 6, some have 8, and some have 10. I would like to
standardize the length of each cell to 10 characters.

Is there a formula that will do this? I could write a macro to do it but
the requirments are for a formula if it is possible. Thanks for the help
 
P

Peo Sjoblom

Do you want max characters 10 in a cell? if so look at data>validation and
text lenght and less than or equal to 10

Regards,

Peo Sjoblom
 
Top