suriyahi
10-02-2008, 09:43 PM
:bug: Hello,
Looking for a solution here. I have got addresses in Col A. So, cells in col. A are in many ways. What I want is, if in the cell, there is word 'United States', I want to remove it and replace with nothing. Second part is in the same column, if cells have Zip code formatted as 12345-6789, I want to remove everything after the dash ('-'). So that, it remains just 12345. For example:
In Cell (A2): St. Petersburg FL United States 33715
I want this to be: St. Petersburg FL 33715
Similarly, if cell (A3) has the following value: OVERLAND PARK KS 66210-1223. In this case I want: OVERLAND PARK KS 66210.
I appreciate your help. Thank you.
Looking for a solution here. I have got addresses in Col A. So, cells in col. A are in many ways. What I want is, if in the cell, there is word 'United States', I want to remove it and replace with nothing. Second part is in the same column, if cells have Zip code formatted as 12345-6789, I want to remove everything after the dash ('-'). So that, it remains just 12345. For example:
In Cell (A2): St. Petersburg FL United States 33715
I want this to be: St. Petersburg FL 33715
Similarly, if cell (A3) has the following value: OVERLAND PARK KS 66210-1223. In this case I want: OVERLAND PARK KS 66210.
I appreciate your help. Thank you.