I need to add spaces into specific places of a cell. For example:
12345678901
23456789012
34567890123
Needs to look like:
12 34 5 678 901
23 45 6 789 012
34 56 7 890 123
I can't figure out how to add more than one space.
Please help me!
I need to add spaces into specific places of a cell. For example:
12345678901
23456789012
34567890123
Needs to look like:
12 34 5 678 901
23 45 6 789 012
34 56 7 890 123
I can't figure out how to add more than one space.
Please help me!
If the first number is in A1, put this in B1 and copy down:
=LEFT(A1,2)&" "&MID(A1,3,2)&" "&MID(A1,5,1)&" "&MID(A1,6,3)&" "&RIGHT(A1,3)
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Try this
Formula:Please Login or Register to view this content.
v A B 1 12345678901 12 34 5 678 901 2 23456789012 23 45 6 789 012 3 34567890123 34 56 7 890 123
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks