How to separate an address in a cell with no spaces

I would like to separate an address in a cell where there is not a space between the street/city and zip code/country

Example: 9550 BLUEGRASS PKWYLOUISVILLE, KY 40299USA

I know how to use "Text to Columns" for each individual cell, but I have a spreadsheet with 1,800 address.

Any help would GREATLY appreciated!!!

Thank you,

Eric

DILIPandey's picture

Hi Eric, Instead of selecting

Hi Eric,

Instead of selecting each individual cell, select entire range (column) and perform "text-to-columns".

A formula can do the task if you have some identifiers in addition of spaces.

Regards,
DILIPandey