Look at Data==Text to Columns or use VBA with SPLIT function. How are the
fields delimited?

"Amy" wrote:

I have cells that contains first name, last name, street address, city,
state, and zip. How do I seperate these into seperate columns.