Text in cells
 

Is it possible to get the text from two separate cells to be inserted
into one cell. For example if I have "Dave" in cell 1, and "Mike" in
cell 2 can I somehow get cell 4 to show "Dave v Mike".

Thanks,

Phil


--
phil2006
------------------------------------------------------------------------
phil2006's Profile: http://www.excelforum.com/member.php...o&userid=35092
View this thread: http://www.excelforum.com/showthread...hreadid=568638

Text in cells
 

A1 = Dave
B1 = Mike
D1 =A1&" v "&B1

It's called the concatenate function. Help will show you examples


VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=568638

Text in cells
 

Thanks very much!


--
phil2006
------------------------------------------------------------------------
phil2006's Profile: http://www.excelforum.com/member.php...o&userid=35092
View this thread: http://www.excelforum.com/showthread...hreadid=568638