In Excel 2007, what is the formula or process to concatenate two text columns into a third column, producing a combination of all their elements?

it's hurting my brain to try to understand what you're really asking for. i'm not sure what you're trying to do exactly because the thought behind the question isn't worded very clearly. anyhow, the 'formula' to concatenate cells together is simply the addition of an ampersand. cell A1 with the text "bork" concatenated with cell B1 with the text "meep" would be: =A1&B1 which evaluates to "borkmeep". you can add in spaces or other text characters by including it within quotes. =A1 & " — " & B1 evaluates to "bork — meep". that's about the best i can do since i don't really understand the entirety of your question. , — while i agree entirely with your sentiments, that people default to excel rather than using a proper database management system, telling someone to "use access" instead isn't very helpful. sometimes we have to use certain programs for specific reasons.

(Note: I didn't know there were tech help type queries on Quora!) One possible method to get combination phrases from two columns without changing the layout of data is as follows. Assuming cell A1 has "dogs", A2 has "cats", B1 has "are animals", B2 has "are dangerous" and B3 has "make noises" Enter the following formula in C1 to C6 (and as many rows as there are combinations): =OFFSET($A$1,INT((ROW()-1)/COUNTA(B:B)),0)&" "&OFFSET($B$1,MOD(ROW()-ROW($B$1),COUNTA(B:B)),0) Adding or deleting new animals or descriptions in columns A and B will automatically generate the necessary combinations.

If you are trying to generate all possible combinations between values in columns A and B, I highly recommend you to check out http://www.searchenginepeople.com/blog/a-search-engine-keyword-variation-generator-in-excel.html and make adjustments based on your needs.

I agree with David's solution but if it has to be done in Excel, then, assuming 10 words in column A and 20 phrases in column B in C1 type =$a$1&" "&b1. Click and drag fill down to the last of the 20 phrases in column B; cell B20. In cell B21 type =$a$2&" "&b1. Drag filldown to B40, and do on. It's a slow method but it'll get you there without resorting to vba.

I would use the following steps - 1. Write 1 to 200 in a new column (call this list SN) 2. Generate all the possible results using concatenate(offset(List1-element1,quotient (SN,20),0),offset(List2-element1,mod(SN,20),0) The idea is to keep a recursive loop using the quotient and remainder functions in excel and using offset to pick values. Let me know if you need more clarity on this

use array ... i mean first list of text you write Vertically and second list of text you write horizontally... concatenate with Vertical and Horizontal cells...