Separate full address

keepgoing

New Member
Joined
Oct 17, 2016
Messages
3
I NEED :help:TO SEPARATE FULL ADDRESS IN DIFFERENT COLUMS OR COMMAS:
Example:
THE WAY I HAVE THE DATA IS LIKE THIS:
[TABLE="width: 373"]
<tbody>[TR]
[TD="width: 373"]5337 N SOCRUM LOOP RD #304 LAKELAND, FL 33809
THE WAY A NEED IT IS LIKE THIS:
[TABLE="class: outer_border, width: 500, align: center"]
<tbody>[TR]
[TD]5337[/TD]
[TD]N SOCRUM LOOP RD #304[/TD]
[TD]LAKELAND[/TD]
[TD]FL[/TD]
[TD]33809[/TD]
[/TR]
</tbody>[/TABLE]
THANK YOU,[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 373"]
<tbody>[TR]
[TD="width: 373"] KeepGoing[/TD]
[/TR]
</tbody>[/TABLE]
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December
You are going to need to give much more sample data than one line. Addresses will vary greatly in format, and patterns will need to be established to come up with a solution that will work on all of your data.
 
Last edited:
Upvote 0
THANK YOU AliGW!!!
LOOK HOW I HAVE IT.

[TABLE="width: 373"]
<colgroup><col></colgroup><tbody>[TR]
[TD]2140-14TH CIRCLE NORTH ST. PETERSBURG, FL 33713[/TD]
[/TR]
[TR]
[TD]9737 NW 41 ST SUITE 182 DORAL, FL 33178[/TD]
[/TR]
[TR]
[TD]2406 LAMEE AVENUE JACKSONVILLE, FL 32207[/TD]
[/TR]
[TR]
[TD]9430 OLDBARN RD ORLANDO, FL 32825[/TD]
[/TR]
[TR]
[TD]14924 SW 142 PL MIAMI, FL 33186[/TD]
[/TR]
[TR]
[TD]1551 NE MIAMI GARDENS DR 321 MIAMI, FL 33179[/TD]
[/TR]
[TR]
[TD]4341 23RD AVE SW NAPLES, FL 34116[/TD]
[/TR]
[TR]
[TD]11511 KELVYN GROVE PLACE JACKSONVILLE, FL 32225[/TD]
[/TR]
[TR]
[TD]1000 NE 6TH BLVD - STE. B-9 WILLISTON, FL 32696[/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0

Forum statistics

Threads
1,223,099
Messages
6,170,111
Members
452,302
Latest member
TaMere

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top