Remove a particular character using formulas
 

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

Remove a particular character using formulas
 

=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 :-)
------------------------------*------------------------------*----------------


"msetyon" wrote in
message ...

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

Remove a particular character using formulas
 

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

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

--
Regards,
Dave


"msetyon" wrote:


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