How to combine each word from column A with each word from col B

[adrianTNT]

Hello, i have two columns of words, lets say col A with 10 words one under another and col B with 10 words one under another, I want to append* each word/row from col A to each word/row from column B resulting 100 words/columns.

COL A COL B
car | red
truck | blue
boat | white

resulting:

car red
car blue
car white

truck red
truck blue
truck white

boat red
boat blue
boat white

Anyone knows the forumla for this? I hope I explained correctly.
Thank you.

[oldchippy]

=A1&" "&B1 copy down

[adrianTNT]

Thanks oldchippy, it doesnt seem to work correctly, I might be entering the formula incorrectly. I do not use excell much.

Do I select the 3rd column and type "=A1&" "&B1" in the Fx box then drag down the corner from the first row of 3rd column?

It seems to simply merge A+B

car red
truck blue
boat white

[Dav]

By formulas the attached may be what you want

Does that help?

Regards

Dav

[adrianTNT]

I did what I wanted with another software but I will still need this in future.

// I made it in adobe flash I created 2 big arrays of words and then I combined them and printed on screen, then took them by copy/paste

Dav, the file you attached has the strings associated correctly but how was it made? When I click a value it shows different formula for each one.
Isn't there one fixed formula that combines all rows?

[oldchippy]

Just adding to DAV's solution in one formula in D1 with space between

=OFFSET(A$2,TRUNC((ROW(A1)-1)/10),0)&" "&OFFSET(B$2,MOD(ROW(B1)-1,10),0) then drag down the column

[bangelta]

=CONCATENATE(A1:A15," ",B1:B15)

change the ranges A1:A15 , and B1:B15 to the columns containing your 2 different text fields.