Text in cells

P

phil2006

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

Thanks,

Phi
 
V

VBA Noob

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

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


VBA Noob
 
Top