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

[@blademirlima4708]

Thanks brother, just saved me a lot of time

[@tjitjilachokwe6764]

Great it saved me 2 hours work. So happy.

[@bgoldpanda7265]

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

[@ittipssolutions8005]

This One is Perfect

[@marinamarjanovic2118]

❤

[@shazadahamedsn]

Tysm

[@dentenver]

Saved my life 🙌🏼

[@muhsaj]

👍🏻

[@debashishtarafdar1033]

Many many thanks 🙏

[@umamaheswari4194]

Thank you so much,♥️♥️♥️

[@angelgarces895]

🎉🎉🎉 thank you

[@itslivthnx]

TYSM 🎉

[@SANGKAYEBOY]

thanks

[@vigneshvanampally3172]

THANKS

[@sincerelysof]

Does this also work for numbers or only for text?

[@jpablo700]

Use the ampersand and be done with it.

[@HalChal673]

How can I add space

[@ImranAli-wb1pm]

❤

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

[@itshowsing9435]

How to exchange two columns?

[@RaosTelangana]

Between insert one colum and space Rabe create one space

[@sunilsingh-fn4er]

Use flash fill

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

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

[@mohindersingh6212]

Concat formula nahi hai?

[@georginjoseph8574]

Try Flash fill

[@RaosTelangana]

easy way =concatenate (a,b,c)

[@babinbabi7545]

How to opposite?

[@hi4u]

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

[@wolfvsman4578]

Ctrl+E

[@Shahzadahmed-od9gg]

its not working on google sheet

[@systemvlogs1010]

Ctrl+E eassy way

[@Prasanthreddyvlogs]

new line i want

[@tsmith9982]

This seems so simple but it isn’t working