How to Combine First and Last Name in Excel

[@ExcelTutorialsEasyClickAcademy]

How to Separate Names in Excel ► kzbin.info/www/bejne/gGLGlKKrf6x1a80

[@johnmichaelkimdeborja773]

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.

[@cinthiam.6495]

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!

[@suddenlyfoster]

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

[@Jamshley]

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

[@andreag3532]

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

[@aalsaadi3673]

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

[@sarafricanadc1789]

Very helpful 😊

[@infernusreyiz7040]

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

[@andrearoux3920]

GREAT Tutorial! Easy, Simple and to the Point

[@endgame5023]

Excellent explanation.

[@Stephanie.0192]

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

[@Mimicomom]

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

[@GentlemanNietzsche]

Thank you Paul this was very helpful

[@mydurhamhouse7776]

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]

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

[@josemacadaeg7580]

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

[@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.

[@nadirhasan5234]

Thank you for the essential tricks.

[@Peggygoldenadolph]

Great and right to the point!

[@christaylor7465]

AWESOME !!! Thanks, worked GREAT!!

[@bijayanandamishra9306]

Ty dear, alot of problem solved❤❤❤

[@tatyanakorzhenko898]

Super! You are the best. So good explanation.

[@battledrill]

You made things so easy! Thank you!

[@ricardosuarez8023]

Brilliant! This is really useful. Thank you.

[@ExcelTutorialsEasyClickAcademy]

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

[@oicrajagiriya1319]

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

[@andreajoseph9208]

Super easy to follow. it worked great!

[@einel18]

Very helpful..thank you 😊

[@bumblevee123]

Wonderful. Thanks! 😊

[@abbytv9681]

thank you very helpful

[@George16437]

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

[@joemarquard7558]

This was a very helpful video!

[@rheaaguirre2598]

very easy to follow and informtive steps..

[@Putravid]

Thankyou so much... you're a hero

[@Shoaibrazallc]

Thank you so much man😊👍

[@camispurlock7640]

Brilliant!! Thank you!!

[@missdiNabyahera]

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

[@palawenavibe1951]

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

[@robynbrown5712]

Loved this Thank You

[@zennyario9571]

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

[@masift1494]

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

[@rjminton534]

Thank you this helped a lot

[@atulpahurkar9153]

Thanks for your help

[@Ladyhadassah]

thank you, it helped🙂

[@FhabyyanRizza]

Thank you, simple but really helpful

[@jaysatya4341]

Many many thanks sir

[@kyliekramer76]

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]

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

[@thaiskitahara4144]

Awesome, thank you very much!

[@devikathampi977]

Thanku for saving my time

[@Lufc-Chaddy]

Thank you, very easy to follow

[@lancesaludo6241]

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

[@chandurante5166]

Thank you!

[@prasenjitnag7043]

Thank you so much sir, you solved my problem,

[@EdgenStyle]

God Bless you.

[@YosephBeyene-u4l]

good job.

[@csees4334]

I just used this but when I went to delete old info it deleted info in cells. Is there a full video of how to safely save new spreadsheet

[@neiljohntolentino6365]

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

[@kangaroomokhtar659]

you are the best thank you so much i subed

[@hasnainsaeed1]

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

[@archanakhelurkar5364]

Thanx very helpful

[@carmelacalimlim7519]

Thank you so much!!

[@rechelbusmeon5352]

Thank you.

[@Carino9999]

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

[@alexis2969]

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

[@krishahouse4972]

Thank buddy it's helpful

[@ExcelTutorialsEasyClickAcademy]

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

[@Kurdkurdi29]

Worked, but there is an issue, when i try search to find a name doesn't give me any result

[@Aveejai]

Thank you 😊

[@ExcelTutorialsEasyClickAcademy]

Jhonavee pleasure to help you :)

[@sineadtohill2982]

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

[@shubhamgulhane3806]

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

[@jidanmahmud142]

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

[@ExcelTutorialsEasyClickAcademy]

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

[@leandersumampong2564]

Thank you

[@maestroandoy481]

Nice video. I prefer to use contatenation operator &

[@vielgandecila7709]

What if the person has 2 names before last name? example: Lopez, Anna Marie? Its hard to do concatenate

[@muntazirkhan4951]

Thank you sir

[@techgrace7]

WOW,AMAZING

[@JanaWright111]

When I drag the formula down the column, it just copies the name in the first cell down to the other cells. How can I fix this?

[@colleenoltmannorfanello1360]

How do you keep the merged names but delete the source cells?

[@ExcelTutorialsEasyClickAcademy]

Colleen, here is video tutorial: kzbin.info/www/bejne/roCYcp5_nM-jrqM :)

[@magin10011]

Does anyone know how to do this, but abbreviate the names?

[@robertrumfelt7843]

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.

[@Balsero-qb9gv]

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!!

[@timroesch7992]

Thanks for the helpful video. There's an extra space on Lily Jones...must be a space after Lily in cell B4. Cheers

[@vinodkumar-ob3eu]

Thanks

[@deepreet511]

You way is so typical I have a essay way

[@kellyknights1783]

Brilliant

[@ExcelTutorialsEasyClickAcademy]

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

[@abdirisakshafi4453]

Thank u

[@NyxNocturnaASMR]

But i need to copy the combined data to another table 😢

[@parenthesis_in]

helpful

[@ExcelTutorialsEasyClickAcademy]

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

[@purplebeard806]

@0:50 to skip the intro

[@suffyanoffice]

thanks soft simple trick learned at age 26

[@VegaSpydr]

This does not help...But okay. I still have to re write every customer name to copy them.

[@ExcelTutorialsEasyClickAcademy]

What exactly did not work for you?

[@suprithapasapula964]

What if there are multiple spaces and comma ?

[@saeedanasir]

Advice to anyone. Listen to it in 2x speed. Helpful video but too slow. Thank you.

[@ExcelTutorialsEasyClickAcademy]

Saeeda, thank you for your feedback :)

[@saeedanasir]

@@ExcelTutorialsEasyClickAcademy Thank you for a very helpful video. 🙂

[@hemalchowdhury9]

This was bullshit isn't working on 2007 excel

[@Abhinavkumar-og3xd]

Please speak in hindi.

[@Mona-ml8lj]

This is too much

[@flair_showers]

Awesome! Thank you!

[@saniikakatamari]

Thank you!

[@educationladder7367]

Thanks a lot

[@ashikurrahmanashik2305]

Thank you so much

[@issaiasbereket2907]

Thank you .

[@Samsunggalaxy-rl9go]

thank you