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?

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

 

[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 ?