View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
michelle michelle is offline
external usenet poster
 
Posts: 310
Default How to format the phone number

Hi,

Can any one tell me how to get rid off the "-" at end of the data
(downloaded from SAP). The data I download from SAP look like this (203)
968-7273-. I would like to get rid off the "-" at the end to make my work
sheet looks better. I have over a thousand rows, so it is almost impossible
to do it manually.
Thanks,
Mickie