Remove a particular character using formulas

M

msetyon

I have excel 2000 and i have having a problem I have a list of roughlt
5000 items that all have "-" in random places I want to remove these
dashes using a formula... not find replace.

Any luck.

Example:
I have "---105--22"
I want "10522"

Thanks in advance for the help
 
K

Ken Wright

=SUBSTITUTE(A1,"-","")

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission :)
------------------------------­------------------------------­----------------
 
D

David Billigmeier

Assume your items start in A1, place this in B1 and drag down:

=SUBSTITUTE(A1,"-","")
 
Top