Adding "Spaces"

  • Thread starter Thread starter carol
  • Start date Start date
C

carol

I have a Column of data :

ColA
A
BTC
FDR

Is there a formula that will make the values in each cell
3 characters ? In other words, convert "A" to "A__".

Thank you in advance.
 
You could use a help column, insert a new
column B

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

copy down as long as needed, while selected copy the values,
do edit>paste special as values in place. Either copy and paste again
over the old values or delete the old values column A

--
For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom
 
Back
Top