Copy cells without splitting column
 

copy the whole column and paste it two columns to the right

then select the original column and do Data=Text to columns and select
delimited and on the next dialog, select comma as the delimiter.

Now delete the column of State Zip that you don't want.

--
Regards,
Tom Ogilvy

"VJ" wrote in message
...
Hello,

I have an excel sheet with about 250 records. I am new to Excel
Programming
and was wondering how to accomplish the following.

I have a column that holds the City, State and Zip details:- | City,
State
Zip |
and want to COPY the City alone and put it in a separate column without
having to split the original column. This should result in the following:-
| City | City, State Zip |

Could someone please tell me how to accomplish this?

Thank you and have a great day,