How to Combine First and Last Name in Excel

Подписаться 251 тыс.

Просмотров 519 тыс.

50% 1

In this video tutorial, we’ll have a look at how to combine the contents of two cells - in this case a first name and a family (or last) name - thanks to which we’ll have a full name merged in one cell. Keep in mind that you’re not limited by the size of the table - you can work with lists much longer than this. It’ll save your time and you’ll avoid dull copying and pasting data bit by bit.
Are you wondering:
How to Separate Names in Excel
► • How to Separate Names ...
How to Merge Cells in Excel
► • How to Merge Cells in ...
================
❤️ Become a Patron:
Do you find our tutorials useful? Join this channel and become a patron
RU-vid ► www.youtube.com/@ExcelTutoria...
================
⏱️Timestamps⏱️
0:00 How to Combine First and Last Name in Excel
1:12 How to Combine First and Last Name in Excel Using ‘CONCATENATE’ Function
3:22 How to Use ‘CONCATENATE’ Function in Other Rows
4:02 How to Change Concatenated Data
================
Is this your first time on EasyClick? We’ll be more than happy to welcome you in our online community. Hit that Subscribe button and join the EasyClickers! :)
► ru-vid.com...
Transcription How to Sort Alphabetically in Excel here
► www.easyclickacademy.com/how-...
Got Microsoft Office 365? Get it here
► www.easyclickacademy.com/buy-...
Connect:
LinkedIn ► / easyclickacademy
Facebook ► / easyclickacademy
Screen Recorder & Video Editor:
Camtasia ► techsmith.pxf.io/c/1266206/34...
Voice over artist ► seanantonyvo.com
#MicrosoftExcelTutorial #ExcelQuickAndEasy #EasyClickAcademy

Хобби

Опубликовано:

22 июн 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 116

@ExcelTutorialsEasyClickAcademy 4 года назад

How to Separate Names in Excel ► ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-J1ccouJGB5k.html

@Jamshley Год назад

Quick, Informative, and to the point! This was exactly what I need ! I was able to follow along and used the formula! CHEERS!

@Mimicomom 3 года назад

Thanks. This was very useful and you just saved me so much time. Very clear instructions and illustrations.

@aalsaadi3673 3 года назад

Absolutely brilliant and so easy to follow ! It worked every step of the way.. tx a mil

@johnmichaelkimdeborja773 2 года назад

Such a huge help specially for the likes of me who are not excel efficient. Very easy to understand, follow and has lots of practical information.

@andrearoux3920 Год назад

GREAT Tutorial! Easy, Simple and to the Point

@cinthiam.6495 2 года назад

You are an excellent teacher! I teach over 500 students a week, and needed to view my students in another program in different ways. This clear tutorial saved me over 3 hours of work. Thank you so much!

@andreajoseph9208 3 года назад

Super easy to follow. it worked great!

@andreag3532 2 года назад

By far the best and easiest tutorial by far.👍👍👍

@christaylor7465 3 года назад

AWESOME !!! Thanks, worked GREAT!!

@lancesaludo6241 Год назад

It was so helpful,thank you so much for this tutorial. Loved it!

@masift1494 Год назад

Such a good tutorial, I'm trying to learn excel for my work and this is perfect.

@Stephanie.0192 10 месяцев назад

Very concise, thank you for saving me hours of work!

@FhabyyanRizza 2 года назад

Thank you, simple but really helpful

@mydurhamhouse7776 2 года назад

FANTASTIC - you save me hrs of work! Now, I also need to go the other way - to separate the street # from the st. name into 2 separate cells.

@shannenreyes3792 2 года назад

You truly taught me this and i wanted to learn this my whole career!!!

@battledrill Год назад

You made things so easy! Thank you!

@Lufc-Chaddy 3 года назад

Thank you, very easy to follow

@ricardosuarez8023 3 года назад

Brilliant! This is really useful. Thank you.

@ExcelTutorialsEasyClickAcademy 3 года назад

Leng, it's been a pleasure helping you :)

@infernusreyiz7040 10 месяцев назад

Thank you so much! It seems pretty useful. You also use a very understandable language.

@suddenlyfoster Год назад

This video came in clutch for a HUGE project for my wife! Thanks, mate!

@oicrajagiriya1319 3 года назад

Thanks. This was very useful and you just saved me so much time. Very clear instructions and illustrations. Thank you soo much'

@zennyario9571 2 года назад

Very informative,, thank you so much,, it makes my work easier. Looking forward for more learnings about excel

@thaiskitahara4144 2 года назад

Awesome, thank you very much!

@rjminton534 3 года назад

Thank you this helped a lot

@camispurlock7640 2 года назад

Brilliant!! Thank you!!

@carmelacalimlim7519 3 года назад

Thank you so much!!

@atulpahurkar9153 8 месяцев назад

Thanks for your help

@Peggygoldenadolph 10 месяцев назад

Great and right to the point!

@josemacadaeg7580 Год назад

Thank you very much for this tutorial. It is a big help for me.

@bumblevee123 Год назад

Wonderful. Thanks! 😊

@abbytv9681 6 месяцев назад

thank you very helpful

@einel18 Год назад

Very helpful..thank you 😊

@joemarquard7558 2 года назад

This was a very helpful video!

@Putravid 2 года назад

Thankyou so much... you're a hero

@GentlemanNietzsche Год назад

Thank you Paul this was very helpful

@nadirhasan5234 Год назад

Thank you for the essential tricks.

@robynbrown5712 Год назад

Loved this Thank You

@tatyanakorzhenko898 2 года назад

Super! You are the best. So good explanation.

@kangaroomokhtar659 4 года назад

you are the best thank you so much i subed

@Shoaibrazallc 2 года назад

Thank you so much man😊👍

@bijayanandamishra9306 7 месяцев назад

Ty dear, alot of problem solved❤❤❤

@rheaaguirre2598 Год назад

very easy to follow and informtive steps..

@krishahouse4972 4 года назад

Thank buddy it's helpful

@ExcelTutorialsEasyClickAcademy 4 года назад

Krisha, it's been a pleasure helping you. Thank you for your feedback. :)

@missdiNabyahera 2 года назад

Thank God I found this super digestible video clip.. yey!

@chandurante5166 2 года назад

Thank you!

@prasenjitnag7043 2 года назад

Thank you so much sir, you solved my problem,

@techgrace7 3 года назад

WOW,AMAZING

@jaysatya4341 2 года назад

Many many thanks sir

@devikathampi977 3 года назад

Thanku for saving my time

@muntazirkhan4951 3 года назад

Thank you sir

@Ladyhadassah Год назад

thank you, it helped🙂

@user-le2po4ks8t 4 дня назад

good job.

@Aveejai 4 года назад

Thank you 😊

@ExcelTutorialsEasyClickAcademy 4 года назад

Jhonavee pleasure to help you :)

@mulavangue 2 года назад

Thank you very much

@ashikurrahmanashik2305 2 года назад

Thank you so much

@archanakhelurkar5364 Год назад

Thanx very helpful

@jidanmahmud142 3 года назад

Thanks bro it is very easy to understand and very helpful Please

@ExcelTutorialsEasyClickAcademy 3 года назад

Glad it was helpful! Jidan, thank you for your feedback :)

@educationladder7367 2 года назад

Thanks a lot

@issaiasbereket2907 Год назад

Thank you .

@palawenavibe1951 2 года назад

Wow thanks. I did it!!!!!!!! 🎉🥳🎉🥳🎉

@George16437 3 года назад

Genius, you should be my teacher. Fully smashing the like button here!! Thank you.

@leandersumampong2564 2 года назад

Thank you

@subcribe9971 2 года назад

thank you

@EdgenStyle Год назад

God Bless you.

@karenmitchell3173 Год назад

Thanks for this, but I cannot delete the individual cells or it will delete the new combined cell. I don't need the individual cells. Help please.

@vinodkumar-ob3eu 3 года назад

Thanks

@abdirisakshafi4453 3 года назад

Thank u

@maestroandoy481 2 года назад

Nice video. I prefer to use contatenation operator &

@dhachutamilinfo 3 года назад

thank u

@robertrumfelt7843 2 года назад

Great video but be advised, text needs to be formatted in "General" format or else the formula itself is displayed rather than the desire result.

@kellyknights1783 4 года назад

Brilliant

@ExcelTutorialsEasyClickAcademy 4 года назад

Kelly, it's been a pleasure helping you :)

@parenthesis_in 3 года назад

helpful

@ExcelTutorialsEasyClickAcademy 3 года назад

Sagar, you’re welcome :) Thank you for your feedback :)

@hasnainsaeed1 3 года назад

how to copy concatenated data? like Tommy Smith in column "D" to some other excel sheet???

@neiljohntolentino6365 Год назад

How about getting the first letter of the middle name. Example. Jose Mandito Rosales- Jose M. Rosales.

@alexis2969 2 года назад

IS there a way to hide the separate first and last name cells? I just want the combined cells to show up on my excel sheet

@kyliekramer76 2 года назад

What do you do if after doing this you need to delete the separate “First Name” and “Last Name” and just have the combined column

@luvuzindagi2024 2 года назад

Hide

@merryk1818 Год назад

Copy the combined column and paste value in the same column then you can delete the first name Nad last name column. I hope this would help you

@shubhamgulhane3806 2 года назад

Great Sir But I'm facing issue after entering formula in results showing formula itself

@sineadtohill2982 Месяц назад

But now when I delete columns for first and last name it removes the entire thing? How do I get round that?

@deepreet511 Год назад

You way is so typical I have a essay way

@Carino9999 Год назад

How about the reverse? I have a column with the full name and trying to separate them.

@Balsero-qb9gv 2 года назад

Thank you very much for this video!! I have a question please, how can I separate the names if they have a minus symbol (-) in between? Example: John-Smith Thank you so much!!