blackystrat
New Member
- Joined
- Aug 5, 2014
- Messages
- 26
Hello
I have a spreadsheet that have 2 columns; Address and City
The addresses end with the city names attached to it, but I also have a separate column with the city names.
<tbody>
</tbody>
What I want is to batch remove all the city names that are appended to the addresses in the same cell. I want to have two distinct columns for address and city name.
Any help with this would be greatly appreciated
Many thanks
I have a spreadsheet that have 2 columns; Address and City
The addresses end with the city names attached to it, but I also have a separate column with the city names.
Address | City |
11305 Via Balboa Anchorage | Anchorage |
P.O. Box 3652 35670 Kenai Spur Hwy. Ste. 102 Soldotna | Soldotna |
P.O. Box 2721 Soldotna | Soldotna |
<tbody>
</tbody>
What I want is to batch remove all the city names that are appended to the addresses in the same cell. I want to have two distinct columns for address and city name.
Any help with this would be greatly appreciated
Many thanks
Last edited: