Thread: how can I remove hypens from a field
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
CLR CLR is offline
external usenet poster
  
Posts: 1,998
Default how can I remove hypens from a field
You could do Edit Replace and replace the hyphen with "nothing", leave
the window blank.........
Or, ASAP Utilities, a free add-in available at www.asap-utilities.com has a
feature that will allow you to delete any given character........

Vaya con Dios,
Chuck, CABGx3




"Ty" wrote:

I have a field that has hypens in the number. I need to remove these hypens
to work with this data. How can I copy this data in a new column, without
the hypens?
--
Thanks, Ty
Reply With QuoteReply With Quote