Two cells into one

juicydeuce

New Member
Joined
Jan 27, 2005
Messages
49
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
 

Some videos you may like

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

Domenic

MrExcel MVP
Joined
Mar 10, 2004
Messages
19,402
If A1 contains 10, and B1 contains 3, try...

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

Hope this helps!
 

Watch MrExcel Video

Forum statistics

Threads
1,118,018
Messages
5,569,652
Members
412,286
Latest member
kychemist00
Top