join

How to merge two columns in Excel without losing data



Sharing buttons:

now we have a table with first name and

last name we want to combine first name

and last name together so we enter eco

can't follow you double click it and

select the first name and the type space

here and click the last one and press

enter now you have first name space

lastly and the price holds the key drag

it to the end now you have first name

last name if you want to delete first

name and the last name row you need a

copy it to here under place day is fine

you select values ok in this case if you

delete the first one

you will say this called him will effect

but it is fine because we copy with mine

of longer fact so that's it for Moore's

the two columns together

you