Adding spaces between all characters in a cell

  • Thread starter Thread starter chunt
  • Start date Start date
C

chunt

Hi,

I have a column of data that contains account numbers and they are
always 7 characters long.

Ex:

1125571
1125585
1125599
1125611
1125619
1125675


I need to be able to add spaces between all of the numbes i.e. 1125571
would become 1 1 2 5 5 7 1 and so on down the line. Is there an easy
way to do this?

Thanks,
Chris.
 
Format cells with the custom number format "0 0 0 0 0 0 0" or use a
text formula:

=TEXT(A2,"0 0 0 0 0 0 0")
 
now what if I have a string of characters/numbers from an equation, and want to add spacing to them, i.e. john smith-> j o h n s m i t h so that I may then encode/decode the characters using the =SPLIT function
 
Back
Top