Text in cells

[phil2006]

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

[VBA Noob]

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

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


VBA Noob

[phil2006]

Thanks very much!