Try this

in C1 put this formula =A1&","&B1 and drag it till u need.



On Sep 23, 8:49*am, "Darrell_Sarrasin via OfficeKB.com" <u33691@uwe
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.comhttp://www.officekb.com/Uwe/Forums.aspx/ms-excel/200809/1