Combine First and Last Name together into one cell using Excel

preview_player
Показать описание
Whether you're organizing data from an email list or cleaning up data, here's a quick video on how to merge (concatenate) two separate cells of data into one.
Рекомендации по теме
Комментарии
Автор

You are amazing, thank you so much. Your instructions are straight forward, precise and give the desired result. You have just saved me time and you have prevented me from stressing.

I am truly grateful. I will share your video on WhatsApp and Facebook so that others may enjoy the grace I just experienced through your thoughtfulness of producing this video.

May God continue to bless you abundantly for being so gracious to many 😃🙏

AmbassadorOfChristSpeakTRUTH
Автор

This is exactly what I was looking for. I’ve never heard of it before. Thank you!!

Fwiw, I searched: “referencing text cells to name a cell”

It’s crazy how hard it is to know what to search for when it’s something you’ve never used or seen before.

daurgo
Автор

You are freaking AWESOME!!! You have no idea how much this video just helped us. We are uploading contacts into our CRM and you just saved the day!!! Thank you for this Ashley!!

Nicholas_Trevillian
Автор

Thank you for such a quick and helpful video!

vrose
Автор

I could have watched someone explain this in eight (!!!!) minutes or watched yours. Thank you for the quick tutorial!

nah
Автор

Thank you for creating this video, it was very helpful

soihdem
Автор

This does not work for me - it gives me an error. I had to do it the following way: =CONCATENATE(A3;B3)

stiaanthecarguy
Автор

But I want to delete column, A and B, and that deletes your formula

fwwl
Автор

But my client received error in formula when I sent him.

BrandGate
Автор

This works however, I need to get rid of the two separate columns and when I delete them I get an error in my combined name cell and the names are gone.

DianeEymann
Автор

=CONCATENATE(B2, “, “, A2) results to: Lastname, Firstname

princessmaravilla
Автор

Thanks, but I can't copy the names from the cells, it shows the numbers etc....that's what I really needed...

iugok
Автор

This has helped me tremendously for my work. Thank you so much, Ashley.

pornpanharris
Автор

But I want to delete column, A and B, and that deletes your formula

fwwl