Merging columns

[Brendon]

Hello

I feel a little silly asking this questionn because I asked it proeviously and now can't find the answer.

I have 2 columns. Column A has first names (let's say 'John'). Column 2 has last names (let's say 'Smith'). Can I merge the columns so that the 1 resulting column has the full name appropriately formatted (i.e. John Smith)?

Thanks for any help.

 

[Nigel Martin]

Hello Bendon,
Say A1=John and b1=Smith
In C1 enter =A1" "&B1
then simply copy it down and delete the original columns if necessary.

 

[Nigel Martin]

PS
Sorry I forgot an &
The formula should read =A1&" "&B1 - entered into C1
Between the speech marks is a space.

Hope this hepls.