Splitting up of Address

VinodGV · Oct 20th 2020

[xpost][/xpost]

Hi

I have a complete address in the sheet1, column A. In this field, I will have details such as US Address, City, State and Zip Code. I need to split them Separately.

Attach the sample file for your reference, would request to assist on this.

**alansidman** · Oct 21st 2020

crossposted: mrexcel.com/board/threads/exce…ress-requirement.1148912/

**royUK** · Oct 21st 2020

The addresses are separated by blanks so you will find it difficult or almost impossible. This will extract the zip code

=RIGHT(A3,5)

VinodGV · Oct 22nd 2020

Thank you Roy for your kindly reply

**royUK** · Oct 22nd 2020

Can you get the source data changed?

VinodGV · Oct 22nd 2020

Hi Roy

It is not possible since the US team provides like that only. I was just curious to know if we can have some formula or code to get rid of it

**royUK** · Oct 22nd 2020

If they were separated by commas it would be easy, but just blanks causes problems, especially when they aren't consistent.

VinodGV · Oct 22nd 2020

Hi Roy

Make sense, it would be separated by commas . We could have use delimiter to separate them.

But this team provides in such a way that it becomes difficult to separate the city, zip and state.

Anyway thank you so much for you kind reply, always appreciate your help

Splitting up of Address

Participate now!

Share