Converting A Cell Entry into a Set # of Characters

C

carl

Can I take the following values and convert them all to 3
character length ?

A
AB
ABC

A would become A__ (A,space,space)
AB would become AB_
ABC stays the same ABC

Thank you in Advance
 
P

Peo Sjoblom

Using a help column

=A1&REPT("_",3-LEN(A1))

copy down

then paste special as values over the old ones or in place

(note that I used the underscore as in your example and not a space,
just replace it)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top