I need to strip off the PL, DR, ST, RD, CIR, LN, etc. from data in address fields.
Is there a function that would allow me to identify the starting positon of any of these strings if they are found in the contents of a cell.
I've tried things like:
=FIND(OR(" PL"," DR"," RD"),a1,1) and some other imaginative functions but without success.
LongFisher
Bookmarks