Excel string extraction 1

[pho01]

One column of my spreadsheet, I have this data extracted from a database in this format:
Column C1: ["Name","Street Address","City, State Zipcode"]

I want to extract Street Address, City, State Zipcode into a different column, N1. How do I do that?

Thanks!

 

[SkipVought]

Hi,

You REALLY want Street Address, City, State Zipcode ALL in one column? REALLY?

Check out Data > Text to columns -- FIXED WIDTH. This will put the data into D1.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[pho01]

Cool! Thanks!