Combine Cell Contents from Two Different Columns in Google Sheets

Combine the data in two (or more) different columns in Google Sheets together. Each row's cells can be merged, and the output is combined with optional extra characters added.

=A2&", "&B2

Learn more from Prolific Oaktree:

#googlesheets #spreadsheets #tutorial

[OoTheShowoO]

this is what every youtube tutorial should be

[AustenSummers]

This was perhaps the first tech tutorial I've gone through in my entire life that only required me to watch through once. Excellent job!

[kathyjoelleaaudiving]

Your video was incredible. No extra words, just simple explanation!! Took me a minute to apply it to my spreadsheet! Loved it! Thank you!

[BrockOwens]

thank you so much, you litteraly have no idea how helpful that was

[kellygallant]

Thank you so much! Accurate, quick, clear and to the point. No preamble - just the good stuff. Great work! 👏

[joshuamartin]

Oh my god I was so frustrated trying to figure this out on sheets! No idea why I didn't YouTube it straight away. Thanks so much for the help. Awesome video.

[TylerPlayer]

just amazingly simple yet super effective. thanks sir.

[shraddhagupta]

Thanks bro... It's really helpful for me.

[tebarron]

OMG! I have been trying to figure out how to do this for over a year. Thank you! Thank You!

[KatzKasting]

I know this video is old, but this is exactly what I have been looking for! Works perfectly! Thank you!

[Onesteve]

Thank you! This helped me save so much time

[siempre]

Thank you! Your video has been very helpful and easy to follow.

[topteamgold]

Thank you brother! You save me a bunch of time. I appreciate you! You rock!

[HansaJeswani-py]

THANK YOU! did the job, made my life easier. Appreciate it so much :))

[rrreaz]

Thank you so much. Saved a lot of time (blessing)

[chrisblades]

Great video - exactly what I needed to know and well presented, thanks.

[bethanderson]

Worked like a charm and saved me a ton of time.

[shahedajakdastaff]

This is great but can you take it a step further and remove columns A and B and keep column C with the data ?

[evangelosgeorgopoulos]

Thank you very much for showing me the way to combine cell data and present them in a single cell.I have not used this way for a long time but your video reminded me the way! Please keep up posting useful content!

[jesusa]

Saved me hours of work, thank you sir!!!