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

Advertisements

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

Advertisements

Joined
Jan 20, 2016
Messages
1
Reaction score
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
 

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