| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
trying to split phone numbers
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
trying to split phone numbers
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) wrote in message oups.com... 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
trying to split phone numbers
Custom (format) as "000 0000 000" (no quotes)
" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert phone numbers with dashes in them to just numbers | Excel Discussion (Misc queries) | |||
| Convert phone numbers with dashes in them to just numbers | Excel Discussion (Misc queries) | |||
| How can I cross reference phone numbers with existing phone numbe. | Excel Discussion (Misc queries) | |||
| Words > Numbers (i.e. Vanity Phone Numbers) function | Excel Worksheet Functions | |||
| Phone Numbers | Excel Worksheet Functions | |||
Linear Mode
