Adding spaces between all characters in a cell

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.
 
L

Lori

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")
 
Top