Thread: insert a space in a phone #. change (123)456-7890 to (123) 456-78
View Single Post
  #4   Report Post  
Jason Morin
 
Posts: n/a
Default
=SUBSTITUTE(A1,")",") ")

HTH
Jason
Atlanta, GA

-----Original Message-----

.

Reply With QuoteReply With Quote