Join 2 cells without merging?

[craigwojo]

Hi everyone,
I have 2 cells that contain data that I need to combine. If I merge the cell it only uses the data from the first cell I select.

Here is what I need.

Leprino Foods Tags Order Motor Numbers.xls
	P	Q	R
95	MTR-	14201	MTR-14201
Lemoore West

 

[Cubist]

In R95, try:

=P95&Q95