trying to split phone numbers

  • Thread starter Thread starter gerry.lisa
  • Start date Start date
G

gerry.lisa

I would like to split 1234567891

into

123 4567 891

and keep it all in the same cell.

Is there a way to split the text this way?

....Lisa
 
Use a custom number format of 000 000 0000


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)
 
You must log in or register to reply here.

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

Mobile phone texts split into incoming and outgoing messages 0
Is there any way to split contents of a cell into more cells. 2
Phone numbers all runnig together 2
How to split number and text string to separate cells? 5
VBA Multiple Line handling with Split() 1
Unique #s in column, need multiple associated numbers in columns 5
custom number formating in a merge table? 1
Converting irregular Word table to spreadsheet 4

Back
Top