Separate full address

[keepgoing]

I NEED TO SEPARATE FULL ADDRESS IN DIFFERENT COLUMS OR COMMAS:
Example:
THE WAY I HAVE THE DATA IS LIKE THIS:

5337 N SOCRUM LOOP RD #304 LAKELAND, FL 33809 THE WAY A NEED IT IS LIKE THIS: 5337 N SOCRUM LOOP RD #304 LAKELAND FL 33809 <tbody> </tbody> THANK YOU,

<tbody>
</tbody>

KeepGoing

<tbody>
</tbody>

 

[AliGW]

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.

 

[keepgoing]

THANK YOU AliGW!!!
LOOK HOW I HAVE IT.

2140-14TH CIRCLE NORTH ST. PETERSBURG, FL 33713

9737 NW 41 ST SUITE 182 DORAL, FL 33178

2406 LAMEE AVENUE JACKSONVILLE, FL 32207

9430 OLDBARN RD ORLANDO, FL 32825

14924 SW 142 PL MIAMI, FL 33186

1551 NE MIAMI GARDENS DR 321 MIAMI, FL 33179

4341 23RD AVE SW NAPLES, FL 34116

11511 KELVYN GROVE PLACE JACKSONVILLE, FL 32225

1000 NE 6TH BLVD - STE. B-9 WILLISTON, FL 32696

<colgroup><col></colgroup><tbody>
</tbody>