How do I put spaces in a field

  • Thread starter Stan in South Africa
  • Start date
S

Stan in South Africa

Office 2003 & 2007, Win XP Pro
I have a list of telephone numbers eg:
0117839178
0866610689
0917142591133
I wish to convert them to:
011 783 9178
086 661 0678
091 714 259 1133
All numbers begin with zero.
Much appreciated.
 
M

Max

Perhaps something like this might suffice
In B1, copied down:
=IF(LEN(A1)=10,LEFT(A1,3)&" "&MID(A1,4,3)&"
"&RIGHT(A1,4),IF(LEN(A1)=13,LEFT(A1,3)&" "&MID(A1,4,3)&" "&MID(A1,7,3)&"
"&RIGHT(A1,4),""))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads: 15,500, Files: 352, Subscribers: 53
xdemechanik
 

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

how do I extract only certain data from a cell? 6
How do I get Outlook 2003 to format my phone number field entries. 2
How do I format cells to show the number 0 as first number in seri 2
How do I convert numbers stored as text with spaces to numbers 1
How do i insert information into the beginning of every field? 3
How to put single space in field? 2
Excel How do I remove spaces from Excel cells 8
How do I enter NUMBERS with leading zeros In Excel ie 001, 002 ? 5

Top