Two cells into one

[juicydeuce]

Hi y'all.

I think I asked this question before, but somehow I cannot find it...
Maybe I asked a friend and thought it was on this board.

Well here is the question.

I have two cells
1st is the number of people and 2nd is number of bats (all in cell format 'number')
in the third cell i want to print ## people with ## bats.
so it should looke like
10; 3; 10 people with 3 bats

I know I have done it before but cannot remember exactly how I did it, and can't find the file!!! ARGH.

Please help me.

Many thanks in advance.

Juicydeuce

 

[Domenic]

If A1 contains 10, and B1 contains 3, try...

=A1&" people with "&B1&" bats"

Hope this helps!