Hi,
I am new to this forum. I have a doubt about concatenation. I have two
colums with different keywords. i have to make all the combinations by
using those words. For an example, i have the following words in the
column A.

Alabama
alaska
arizona
texas
washington

and in Column B I have the following words

hotel
theatre

i want to combine both the columns. i want the output like this.

alabama hotel
alaska hotel
arizona hotel
texas hotel
washington hotel
alabama theatre
alaska theatre
arizona theatre
texas theatre
washington theatre

What function i have to use for this? please tell me procedures. i
can't do anything manually. i have used the concatenation function
already. but i can't use that for my words. because i have 40 words in
column A and 15 words in column B. So, please tell me the possibilities
and procedures.

Thanks


--
uma
------------------------------------------------------------------------
uma's Profile: http://www.excelforum.com/member.php...o&userid=33632
View this thread: http://www.excelforum.com/showthread...hreadid=534045