combine columns

I need instructions on how to combine the contents of three(3) spreadsheet plain text columns in a google docs spreadsheet?

The columns contain content as follows.

Content Content Content

The output should be Content, Content (Content) all in one (1) column as opposed to three (3).
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:

concatenate the contents of the columns with the & sign.

In column D, for example, with your three other columns being A, B and C

=A1&", "&B1&" ("&C1&")"

cheers, teylyn

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
see screenshot
rtod2Author Commented:
Wow.  Nice!

Lightbulb moment.  The quotations " " don't appear to follow a pattern?  What do they do?
Exploring ASP.NET Core: Fundamentals

Learn to build web apps and services, IoT apps, and mobile backends by covering the fundamentals of ASP.NET Core and  exploring the core foundations for app libraries.

Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
They DO follow a pattern. They are text strings and the " signs delineate the beginning and the end of a text.

" " - a space
" (" - a space and an opening brace
")" - a closing brace

Maybe it gets clearer with some spaces:

=A1  &  ", "  &  B1  &  " ("  &  C1 &  ")"

(don't use the space version in the spreadsheet, though.
rtod2Author Commented:
I'm even more confused about when to use quotation marks but it makes perfect sense to me now why one would use an & sign.  

Thank you very much!

Your code worked a charm.
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
The & operator is used to concatenate text. Text in a formula must be wrapped in double quote signs.

Say we have three bits of text:


If they are stored in cells A1, A2 and A3, we can concatenate the texts by using


which will deliver


It is also possible to use a text string directly with the concatenation operator & in a formula.


See how the actual text is wrapped in double quotes. "Apple" and "Orange" and "Plum". Each text consists of an opening quote sign, the text itself and a closing quote sign.

Now, if we wanted to use a space between the words, we need a piece of text that consists of just a space.

" "

An opening quote sign, a space and a closing quote sign.

=A1 & " " & A2 & " " & A3

In the same way, we can have bits of text that consist of a space and a bracket.

" ("

Or text that is just one character, for example a closing bracket


When you read a formula and come upon a " sign, put your left thumb on it. Then read on and find the next " sign. Put your right thumb on it. Now everything between your thumbs is one continuous piece of text.

Make sure you have a screen cleaning kit handy.

It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.