EXCEL: REMOVING A SPECIAL CHARACTER IN A STRING OF ALPHA/NUMERICS

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Ron,

Go to Edit->Replace. Enter a dash for "Find what", and leave "Replace with"
as blank. Click on Replace All.
 
Back
Top