Combine Text from Two Cells in Excel 2010

[@allenroughton]

Actual info begins at 2:30

[@altayyaroverseasemployment5235]

THANKS

[@akrkhan5009]

The first few minutes are useless....BTW this video saves my time for the trick....thanks for the useful video

[@arthurbotting9557]

Thank you for making this video!

[@findmeeh8520]

I love you, this is very helpful to me, I meant it

[@samiasrar]

Thanks a lot Mandy Orzechowski, it saved my day...

[@quillinggal9654]

So much useful information! Thank you !

[@MandyTCTC]

So glad it was helpful

[@johnmarimigallon9274]

Thank you so much! It helped me a lot!

[@omerfaruk-hh2ny]

Very effective method. Thanks

[@saiecorp5646]

Very nice, very useful information. Thanx.

[@freelancetechit]

Very helpful video. Thank you.

[@saiblounis8181]

Thank you so much.

[@MandyTCTC]

You're welcome!

[@marcoslakwatsero2930]

Thank you. Save of Time.

[@johannestshitaka2357]

I use the same excel 2010 but it doesnt do that please help

[@SKATEINFORMANT]

i get stuck when I try to click and hold...small black cross doesnt appear :-(

[@zurielauguiste]

Thanks!

[@jeremyhooter8289]

Thank you so much for that!!!!

[@pranavb25]

Thank You!

[@MandyTCTC]

You're welcome!

[@harsimransingh6189]

Thanks

[@davoodkarimi5752]

Thx in a zillion

[@rajukhaza5086]

Thank you very much

[@guesswhat2710]

Thnx

[@wesellanybiz]

But when you delete the columns A and B then the names show as REF!! Please help how to fix this?

[@MandyTCTC]

Copy the row with your combined text, then paste it in the next row, but use paste special. Select values for the paste. Then you can delete all three of the other columns

[@MandyTCTC]

Row or column, depending on how your data is arranged

[@paulettestubbs8326]

this did not work.. what did I do wrong

[@matthewaislabie7354]

Thanks, but could be 30seconds.

[@rajashekharg634]

Thank you very much

[@albanvencilaus5029]

THANKS