Excel Question

[Fiveohhh]

I received a roster in excel with names and address' and the Names are in a last name, first name in one column. My question is: Is there a way to get Excel to automatically seperate them? There is a comma inbetween the two. I really don't want to have to type them all out.
Thanks

 

[Radiohead]

Yes
Highlight the names, go to Data, select Text to Columns, and follow the instructions

 

[Fiveohhh]

Awesome thanks alot.

 

[Fiveohhh]

Doh, one more question I want to Parse out the address' also now it's 1234 x St N yourtown, State, Zip. They're all in MN, and the zips are all 55xxx or 56xxx, wanted to use those as a delimiter, but only could put one Letter in there. This isn't too imperative, but would be convenient
Thanks Again for your help, Allready saved me an afternoon

 

[Radiohead]

Originally posted by: Fiveohhh
Doh, one more question I want to Parse out the address' also now it's 1234 x St N yourtown, State, Zip. They're all in MN, and the zips are all 55xxx or 56xxx, wanted to use those as a delimiter, but only could put one Letter in there. This isn't too imperative, but would be convenient
Thanks Again for your help, Allready saved me an afternoon

Not sure if I follow you.
Couldn't you just deliminate them by the commas in between Street Address, City, State, Zip?

 

[Fiveohhh]

Oops the comma aren't supposed to be there. its: address City State, zip. I allready got the zip off using the comma.

 

[Radiohead]

If I have this right, if you were to use the space deliminator, the separation will occur between every field.
so it'll wind up looking like:

(Column A) address (Column B)street (Column C)city (Column D)state

So the downside is that the address and street get separated when they are suppose to be joined

But you can join the two columns together with a formula.
If the address (number part) is in Column A & the street part is in Column B, the formula would be
=A1&" "&B1

This would join the two columns together, but separate them with a space.

Hope this helps

 

[Fiveohhh]

It would work, but some of the streets have a N or S, some or more than one word. Thanks for your help though.

 

[Radiohead]

Originally posted by: Fiveohhh
It would work, but some of the streets have a N or S, some or more than one word. Thanks for your help though.

Ah yeah, forgot about that.

Yeah I can't think of any other way without making it too complicated.

 

[Fiveohhh]

No worries Thanks again for the help