Blessy Clara
Board Regular
- Joined
- Mar 28, 2010
- Messages
- 201
Hi,
i have an excel sheet with an Address column - The Zip code is repeated twice in the column and i wanna remove the repetition -
<tbody>
</tbody>
Thank you in advance for your time and effort
i have an excel sheet with an Address column - The Zip code is repeated twice in the column and i wanna remove the repetition -
Zurich House, Level 5, 201 Leichhardt St Spring Hill QLD 4004 , 4004 | Zurich House, Level 5, 201 Leichhardt St Spring Hill QLD 4004 |
Zurich House, 6/ 75 Denham St Townsville QLD 4810 , 4810 | Zurich House, 6/ 75 Denham St Townsville QLD 4810 |
Zunker St Burnett Heads QLD 4670 , 4670 | Zunker St Burnett Heads QLD 4670 |
Zaknic Pl Bunbury WA 6230 | Zaknic Pl Bunbury WA 6230 |
1st Floor, 7 Bayfield St Rosny TAS, 7018 Australia , 7018 | 1st Floor, 7 Bayfield St Rosny TAS, 7018 Australia |
address | Result |
<tbody>
</tbody>
Thank you in advance for your time and effort