ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how can I remove hypens from a field (https://www.excelbanter.com/excel-discussion-misc-queries/125206-how-can-i-remove-hypens-field.html)

ty

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

CLR

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


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