Hello,
I have Street Names in Column A. They are all different and may contain apartment or unit numbers at the end.
I would like to search the text in the cell from RIGHT to LEFT to find the first instance of "ST" or "AVE" or "RD". I would then like to remove any text to the right from that...