combine cells
 

Hi,
If what you mean is two columns with names and you want to get only one
column with that two if the columns are A and B in C enter

=A1&""&B1

The "" will do the space between both column if you need more space just
left blank spaces between the ""

Hope it help
"exceler" wrote:

I have 2 lists of names in the same worksheet. I want to alphabatise the two
lists into 1 list.