Merge OR Concatenate two columns in Ms Excel

In this shorts, I tried to show you how you can merge or concatenate two columns in Ms Excel
#excel #msexcel #excelformulas #excelsupport #exceltutorial #exceltips #exceltricks #excelformula #excelformatting #excelbeginners #excelforbegginers #msexcelcourse #excelshortcuts

[@tjitjilachokwe6764]

Great it saved me 2 hours work. So happy.

[@blademirlima4708]

Thanks brother, just saved me a lot of time

[@bgoldpanda7265]

An easier way is to do =A1 & “ “ & B2

[@ittipssolutions8005]

This One is Perfect

[@marinamarjanovic2118]

❤

[@shazadahamedsn]

Tysm

[@dentenver]

Saved my life 🙌🏼

[@muhsaj]

👍🏻

[@jpablo700]

Use the ampersand and be done with it.

[@angelgarces895]

🎉🎉🎉 thank you

[@umamaheswari4194]

Thank you so much,♥️♥️♥️

[@debashishtarafdar1033]

Many many thanks 🙏

[@sincerelysof]

Does this also work for numbers or only for text?

[@itslivthnx]

TYSM 🎉

[@SANGKAYEBOY]

thanks

[@vigneshvanampally3172]

THANKS

[@RaosTelangana]

Between insert one colum and space Rabe create one space

[@HalChal673]

How can I add space

[@RaosTelangana]

easy way =concatenate (a,b,c)

[@bryantmunozsantos2532]

How to I delete data from those two columns without effecting the new merged column

[@andyr4735]

You'd need to copy the data from the new merged column them paste as values only. That then removes the link so if you delete the other two columns or make any changes the new column wont change

[@ImranAli-wb1pm]

❤

[@wolfvsman4578]

Ctrl+E

[@sunilsingh-fn4er]

Use flash fill

[@georginjoseph8574]

Try Flash fill

[@ryanroberts3241]

I want to know where this music came from. I love it!

[@liltosui]

something they can never own-nefex

[@liltosui]

probs the instrumental or the last 10 seconds of the song

[@ryanroberts3241]

@@liltosui Thank you!

[@itshowsing9435]

How to exchange two columns?

[@systemvlogs1010]

Ctrl+E eassy way

[@hi4u]

Antha kastam enduku.... flashfill use chesthe easy ne ga

[@mohindersingh6212]

Concat formula nahi hai?

[@stardomee]

I know another way: =A2&" "&B2

[@jiya1933]

Thank you

[@jiya1933]

What if we need space in between?

[@AstraCastra]

Thanks . This worked for me

[@LisiJanVentures]

YOU BLOODY GENIUS. I CAN'T SEE HOW HE GOT CONCAT TO COME UP. THANK YOU

[@mohamedrmaidi8850]

A savior thank u!

[@babinbabi7545]

How to opposite?

[@tsmith9982]

This seems so simple but it isn’t working

[@Shahzadahmed-od9gg]

its not working on google sheet

[@Prasanthreddyvlogs]

new line i want