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?

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?

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?