merge contents of 2 cells into one

Hi

Hoping that someone can pick this up as its something that has always annoyed me.

I have a list of names on 1 sheet with relevant details of the team they are in and on another sheet I have a list of the same names with the comments they have made to a recent survey.

What I want to do is to use a VLOOKUP function to match the comments with the group. The problem I have is that on the 1st sheet the forename and surname are together in one cell. In the other sheet the forename and surname are across 2 cells.

what I was looking around for was some kind of function that would combine the 2 together into 1 cell for use in a VLOOKUP

Really appreciate any thoughts or help

To combine the contents of the 2 cells try:
=A1&" "&B1
With forename in A1 and surname in B1 the formula gives you the names combined with a space between them.
Alternatively check out the CONCATENATE function.