Surnames are in column A and given name is in column B. It's the given names
I want to move.

"David Biddulph" wrote:

=IF(LEFT(A2)=" ",RIGHT(A2,LEN(A2)-1),A2)
--
David Biddulph

"Lacey1941" wrote in message
...
I have a rather long list of names and some of them have a space at the
beginning while others don't.

Is there a way to move whole groups of names over one space or will I have
to move them manually one name at a time?