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

TSCGCobra043

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

Similar Threads

Adding spaces between numbers in a cell that contains a full address 4
Comparing characters in cells 7
Can't Explain N/A in Vlookup 2
Group List by Values in Column A and combine related row values inColumn B into 1 Cell 7
Extract all text without spaces and special characters 4
Cut characters from one cell to form a newcell 2
Wildcard characters in formulas 1
Formula/Function for Counting Characters in a cell 4

Top