how can I remove hypens from a field
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 |
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 |
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 |
All times are GMT +1. The time now is 09:21 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com