View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
ty ty is offline
external usenet poster
 
Posts: 19
Default how can I remove hypens from a field

THANKS!
--
Thanks, Ty


"CLR" wrote:

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