You can't automatically but you can use a helper colomn to combine the data.
In C1 insert something like this...
=A1&"_"&B1
copy the formula down the list
copy the colomn and paste special selecting values
then delete the unwanted or/and old columns

FYI:
=A1&"_"&B1
converts John Smith to John_Smith
=A1&" "&B1
converts John Smith to John_Smith
=B1&", "&A1
converts John Smith to Smith, John


"VPP Industries" wrote:

Hello, I have an excel file from a customer and I have to combine their first
and last name into 1 column. They have the first name in column A and the
last name in column B. I need to get these into 1 column so they can be pout
into the UPS System. Thanks in advance!!!!