| 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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
EXCEL: REMOVING A SPECIAL CHARACTER IN A STRING OF ALPHA/NUMERICS
Ron,
Go to Edit-Replace. Enter a dash for "Find what", and leave "Replace with" as blank. Click on Replace All. -- Hope that helps. Vergel Adriano "RON I" wrote: 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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
EXCEL: REMOVING A SPECIAL CHARACTER IN A STRING OF ALPHA/NUMERICS
and please stop SHOUTING. all caps = shouting.
:) susan Jul 25, 8:00 am, RON I <RON wrote: 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? |
| Reply |
| 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) | |||
Linear Mode
