Insert spaces in text string in Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have text stings comprised of twenty characters, eg. 89014104201060525494
I want to add four spaces between every fourth character, eg. 8901 4104 2010
6052 5494. How can I format a cell to do this in Excel?
 
I'm not convinced you can do it by formatting, but you could use a helper
column, along the lines of
=LEFT(A1,4)&" "&MID(A1,5,4)&" "&MID(A1,9,4)&" "&MID(A1,13,4)&" "&RIGHT(A1,4)
 

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

Validation a character in a string 1
Pullng data out of string of text 4
Inserting a decimal from the right of a string 6
Excel Help creating Excel formula 1
Problem in Conversion of Excel to Text(Tab delimated) 1
Help with formula 4
long number ends in 000 2
Data being corrupted by excels automatic date recognition re-forma 6

Back
Top