Thread: Changing digits in a cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Carim[_3_] Carim[_3_] is offline
external usenet poster
  
Posts: 137
Default Changing digits in a cell
Hi Hemming,

If your data is located in cell A1, this formula :
="("&LEFT(A1,3)&")"&MID(A1,4,3)&"-"&RIGHT(A1,4)

should do the job ...
HTH
Cheers
Carim

Reply With QuoteReply With Quote