Thread: trying to split phone numbers
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Toppers Toppers is offline
external usenet poster
  
Posts: 4,339
Default 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 With QuoteReply With Quote