| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
EXCEL: REMOVING A SPECIAL CHARACTER IN A STRING OF ALPHA/NUMERICS
I HAVE A SPREAD SHEET WHERE SEVEAL PEOPLE HAVE ENTERED DATA. UPON FINAL
EDITING, FOUND THAT ONE PERSON ENTERED A "-" IN THEIR SEQUIENCE OF CHARACTERS IN A COLUMN. EXAMPLE: 01-12V 02-002 01-2D3 NEED THEM TO READ: 0112V 02002 012D3 THERE ARE APPROXIMATELY 1000 ENTRIES TOTAL, OF THOSE ABOUT 400 HAVE THE DASH. HOW CAN I HAVE EXCEL FIND AND DELETE THE DASH? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| separation alpha numerics | Excel Discussion (Misc queries) | |||
| Removing character in a string | Excel Discussion (Misc queries) | |||
| test if a character in a string is alpha | Excel Programming | |||
| remove special character at end of string | Excel Discussion (Misc queries) | |||
| NEED HELP-----Removing a space at the end of a string of character | Excel Discussion (Misc queries) | |||
Threaded Mode
