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


--
msetyon
------------------------------------------------------------------------
msetyon's Profile: http://www.excelforum.com/member.php...o&userid=29277
View this thread: http://www.excelforum.com/showthread...hreadid=489953