trying to split phone numbers

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
 
C

Chip Pearson

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)
 
Top