![]() ![]() In Cell D2, please enter the formula =A2&B2&C2, and then drag the AutoFill handle down to apply the formula to other cells in the active column.Īnd the columns of data have been merged into one column. ![]() ![]() If you need to merge multiple columns of data into one column without any data losing, you can apply formulas to deal with it in Excel.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |