Home » Forums » Open Source Learning Center » Question and Answer

How to separate an address in a cell with no spaces

Submitted by eimsande on 1 August, 2014 - 12:41

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

‹ Help with Excel dilemma Remove Duplicates - base on two columns Complicated ›
»
DILIPandey's picture

Hi Eric, Instead of selecting

Submitted by DILIPandey on 14 August, 2014 - 07:36.

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

»