Thread: EXCEL: REMOVING A SPECIAL CHARACTER IN A STRING OF ALPHA/NUMERICS
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
RON I RON I is offline
external usenet poster
  
Posts: 1
Default 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?
Reply With QuoteReply With Quote