Combine First and Last Name in Excel (Using Formulas, Flash Fill, Power Query)

@TrumpExcel, I have the formula to combine First, Middle and Last, but I'm having a space between first and last for names that don't have a middle name. What is the solution? Thank you

Im just trying to do a simple table representing different jobs, and shift times for those jobs. Once i select the appropriate job & shift. Im trying to select from a drop down list of available names. Once I select the correct name. Their indicative data or Name, phone number and email. Populates under the job in the appropriate shift time. What am I doing wrong. Please someone help with info or direction to info on set up

You are a great teacher, thank you.

I like your videos, good explanation brother

Thank you , I learnt a lot

Hi Sumit Bansal - Too good 👌 Thank you so much

Excelent Sumit!! Many thanks

TEXTJOIN is far superiority you have quite a few things to join. Same goes for Power Query if you don’t want formulas

Flash Fill is quick and easy if you aren’t going be adding or changing data

Great tutorial as always

Thanks Sumit! Great examples. Thumbs up!!

Excellent Sir..

Thank you, Sir!! Amazing presentation and teaching as always!!

💞👌🏼

Excellent functionality. Great video. Thank you Sumit Bansal!

New video after a long time.....kindly upload videos regularly

Have used all other options except the power query.

Thank you.

Good

Superb