What I need to do is a massive search-and-replace-type thing.
Specifically, I have a ton of addresses. I want to edit out the useles
and repetative words like RD, LANE, PKWY, NORTH, SOUTH, NW, AVE.
etc... and basically be left with "123 Maple 405" instead of "123 S
Maple APT # 405".
I have a nice column of items to be deleted, but I can't figure out ho
to apply that field to my other field of addresses.
I have used the SUBSTITUTE command, but it seems to work on only on
cell at a time. I need to specify ranges of cells.
Let's assume my addresses are in a1:a1000 and my "bad" phrases are i
c1:c25. My output column will be B1:b1000.
In B1, I can put:
=SUBSTITUTE($A1,$C$1,"")
I can copy it down the column and it works fine for a singl
substitution (C1). But, what I need to do is something like this:
{=SUBSTITUTE($A1,$C$1:$C$25,"")}
Except that the above line doesn't work. It outputs exactly what th
source text is.
Am I going about this the completely wrong way or do I just need t
tweak it a little
--
Message posted from
http://www.ExcelForum.com