Bob, that was to simple. I have been trying to combine an IF statement with
the substitute and it just would not work. Thank You. Now if I could get
this to work in access my day would be complete. Any thoughts on this? I
really need to perform this in Access and I just found out this morning that
Substitute is not a built in function. I am going to try it in VBA and se if
that will work. Again, Thanks

Bob Phillips wrote:
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,".",""),"/",""),"-","")

--

HTH

Bob Phillips

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

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
[quoted text clipped - 6 lines]
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.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200610/1