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.