Try this eg.
A1 = Red
B1 = Apple

Type the following in C1 =A1&B1

you get RedApple

if you want a Space in between the two words type this in C1 =A1&" "&B1



"TotallyConfused" wrote:

Can someone please tell me how to concactenate fields in Excel?