How to Separate One Column Into Many Columns with No Delimiter
 

Hello,

I was wondering if it is possible to divide one given column into multiple columns for which there is no delimiter or uniform width space.

Here is an example of 3 rows of the data -

Location Address City State Zip Phone Number Fax Number Email Address
Kinokuniya Plaza 11803 Kino Ln Newark New Jersey 39841 (804) 454-9998 N/A
Mythos Place 93 Santos Drive San Francisco California 99312 (626) 123-9088 N/A

Any help would be truly appreciated

Thank you in advance!

How to Separate One Column Into Many Columns with No Delimiter
 

On Sat, 18 Nov 2017 19:10:45 +0000, needExcelHelp90 wrote:


Hello,

I was wondering if it is possible to divide one given column into
multiple columns for which there is no delimiter or uniform width
space.

Here is an example of 3 rows of the data -

Location Address City State Zip Phone Number Fax Number Email Address
Kinokuniya Plaza 11803 Kino Ln Newark New Jersey 39841 (804) 454-9998
N/A
Mythos Place 93 Santos Drive San Francisco California 99312 (626)
123-9088 N/A

Any help would be truly appreciated

Thank you in advance!

Not simply or without preprocessing.

The header line parses easily at spaces.

Others, not so much.

Newark New Jersey: one word for city, two words for state
San Francisco California: two words for city, one word for state