Thread: insert a space in a phone #. change (123)456-7890 to (123) 456-78
View Single Post
  #3   Report Post  
N Harkawat
 
Posts: n/a
Default
And a formula based approach
=MID(A1,1,5)&" "&MID(A1,6,10)

"leo" wrote in message
...



Reply With QuoteReply With Quote