switching last name/first name

I have a column of cells that have the last name first then the first name. Example:

C1
Smith John

Is there a formula/macro that can switch them all?

It works.....but I have to delete the original cell......anyway to copy it the new cell with just the information and not a formula?

Don't know if I need to do a new post for this or not but one last thing I need is I have a cell with address, city, state and zip but I need to take the city "whitney", the state and the zip code out of that cell and put them in their own cells. Example

B1
01467 Brookside Dr, Whitney TX 76692

B1 C1 D1 E1
01467 Brookside Dr Whitney TX 76692


How can I do this?

Hi,
this is a little tricky, but you could do it with several Text to Columns operations

First text to column with Comma as the delimiter - that would leave you with two cells

01467 Brookside Dr ----- Whitney TX 76692

(where ----- is the column boundary)

next, do text to column on the second column with space as the delimiter
next, insert a few columns before the city and do a text to column on the first column, again with space as the delimiter
finally, combine the second and third column with a concatenation and then copy and paste all columns the way you need them.

Well I was able to get the state and zip out of the cell but now have an issue trying to get the city out because what was separated with a comma was the city, state......not street, city. Whitney is now the last word in the cell though.....is there a formula that can just take out the last word in a cell and paste it into another one?

I posted my last response late last night but still need to know how I might do my last question. Any help?

Please please please......can someone help?