In an un-used column enter:
=A1 & ", " & B1 and copy down

Then take the new column, copy it, and paste/special/values back onto column
A.
--
Gary''s Student - gsnu2007k


"Darrell_Sarrasin via OfficeKB.com" wrote:

I am creating reports from a precreated excel document. my boss wants me to
take two columns and combine them Example column A is last name and Column B
is first name. She wants it to read last, first name. if it was a small doc
would not be bad but we have 10000 entries in the form. please help.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200809/1