Moving data from a string

[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

 

[Ron Rosenfeld]

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

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