Thank you so much. This forum is very much appreciated.

"claude jerry" wrote:

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?