| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Field not visible in ptable field list | Excel Discussion (Misc queries) | |||
| Display the source for a pivot table page field | Excel Worksheet Functions | |||
| Pivot Table: Remove old field cell value | Excel Discussion (Misc queries) | |||
| Pivot Table - Remove "sum of" in data field | Excel Discussion (Misc queries) | |||
| Changing a text field to a date field | New Users to Excel | |||
Linear Mode
