Combining Text

I am sure this has been answered many times before, but I searched and couldn't find anything.

I want to combine two lists of words to create a third list. For example if my two lists are

1st Column
Pub
Restaurant

2nd Column
London
Manchester
Birmingham

I want to automatically create a column with a list
Pub London
Pub Manchester
Pub Birmingham
Restaurant London
Restaurant Manchester
Restaurant Birmingham

each in a separate cell.

Thanks for any help you can give me.

Hi

If your first list starts in col A1 and your second in B1

In C1

=a1&" "&B1

and copy down

Ed

Maybe something like this?
kw killer: Pub Restaurant London Manchester Birmingham

Please Login or Register  to view this content.