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

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Rick5k" <u28335@uwe wrote in message news:684fc6639b122@uwe...
I have a need to clean/remove dots, dashes, and slashes from a series of
part
numbers. The numbers look something like the following: AI246-34-D/34 I
need it to look like AI24634D34 I can use the Substitute function to get
rid
of the dashes or get rid of the slash, but when I try to combine them and
get
rid of both I get an error on the formula. Some of the part numbers, I am
using numbers here loosely when these are actually text, have dots and
dashes,
and some of the slashes are right not only left slahes. I'm sure that
there
are other charactors in some of them. But I need one formula that I can
put
all the charactors I want to get rid of and clean up these numbers so I
can
work with them the way I need to. Can anyone help me here.