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

[@bgoldpanda7265]

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

[@ittipssolutions8005]

This One is Perfect

[@marinamarjanovic2118]

❤

[@shazadahamedsn]

Tysm

[@dentenver]

Saved my life 🙌🏼

[@muhsaj]

👍🏻

[@blademirlima4708]

Thanks brother, just saved me a lot of time

[@tjitjilachokwe6764]

Great it saved me 2 hours work. So happy.

[@sincerelysof]

Does this also work for numbers or only for text?

[@jpablo700]

Use the ampersand and be done with it.

[@angelgarces895]

🎉🎉🎉 thank you

[@debashishtarafdar1033]

Many many thanks 🙏

[@umamaheswari4194]

Thank you so much,♥️♥️♥️

[@itslivthnx]

TYSM 🎉

[@RaosTelangana]

Between insert one colum and space Rabe create one space

[@itshowsing9435]

How to exchange two columns?

[@SANGKAYEBOY]

thanks

[@vigneshvanampally3172]

THANKS

[@sunilsingh-fn4er]

Use flash fill

[@HalChal673]

How can I add space

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

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

[@mohindersingh6212]

Concat formula nahi hai?

[@ImranAli-wb1pm]

❤

[@georginjoseph8574]

Try Flash fill

[@wolfvsman4578]

Ctrl+E

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

[@hi4u]

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

[@systemvlogs1010]

Ctrl+E eassy way

[@babinbabi7545]

How to opposite?

[@Shahzadahmed-od9gg]

its not working on google sheet

[@Prasanthreddyvlogs]

new line i want

[@tsmith9982]

This seems so simple but it isn’t working