How do I parse a cell that contains the company name and address.

[DonnaS]

How do I parse a cell that contains the company name and address? The previous cell has the company name if that helps?

Customer	Ship to
100% KIDS	100% KIDS 485 CENTRAL AVE CEDARHURST, NY 11516
24 HOUR FITNESS	UPS-SCS: 24 HOUR FITNESS 11991 LANDON DR MIRA LOMA, CA 91752
2 HOT YOGA	1808 Old Briar Rd Highland Park, IL 60035
432 WEST SIDE	432 WEST SIDE BELLEAIR BLUFFS PLAZA 100 INDIAN ROCK ROAD BEL
4 KIDS ONLY - TX	4 KIDS ONLY 2900 W WASHINGTON, #120 STEPHENVILLE, TX 76401
4 SISTERS 1 CLOSET	7080 nw 4th St PLANTATION, FL 33317

<tbody>
</tbody>

 

[DonnaS]

YOU ARE AMAZING!!

Any way to separate the cells by Address|City|State|ZipCode knowing that the fields follow any specific format?

 

[Gerald Higgins]

Yes, this can be done, IF you have a specific format.

What is your format ?

The examples you have posted don't seem to have a consistent format.

 

[DonnaS]

Sorry correction - Any way to separate the cells by Address|City|State|ZipCode knowing that the fields DONT follow any specific formatt?​

 

[Gerald Higgins]

I don't see how.

Consider this from one of my earlier posts in this thread . . .

Forgetting about Excel specifically for a moment . . . taking your sample data, how exactly would YOU instruct someone else to parse out the company name ?

If you want to get a person / computer to do this, you have to somehow give the person / computer instructions on how to do its task.
Simply saying "Break it into Address / City / State / Zipcode" is not enough.
How does the person / computer know where an address ends and a city starts ?