Moving data from a string

  • Thread starter Thread starter Lacertadeus
  • Start date Start date
L

Lacertadeus

I have a rather complex problem, at least it is for me.

I have a column full of addresses.

1234 common way, city, state zip

I want to take the column and split it into at least 2. Such that the
street address and the CSZ are in seperate columns.

A B
1234 common Way, city, state zip

I have zero experience with basic and almost none with excel so can
someone please help me?

Thanks
 
I have a rather complex problem, at least it is for me.

I have a column full of addresses.

1234 common way, city, state zip

I want to take the column and split it into at least 2. Such that the
street address and the CSZ are in seperate columns.

A B
1234 common Way, city, state zip

I have zero experience with basic and almost none with excel so can
someone please help me?

Thanks
Click to expand...


Select your column
Select Data / Text to columns
Delimited
<next>
Comma
<finish>

That will leave you with | state zip | in the rightmost column.

If the 'state' is the two letter abbreviation, repeat the above with a slight
change:

Select Data / Text to columns
Delimited
<next>
Space
<next>
select the column containing the zip codes and format it as Text
<finish>
--ron
 
Back
Top