Splitting Names

[Vidcapper]

If I had a column of names in the format :

'Firstname Surname'

Is there a way I could extract just the surname to a different cell?

TIA.

 

[Claus Busch]

Hi Paul,

Am Fri, 31 Oct 2014 16:02:28 +0000 schrieb Vidcapper:

If I had a column of names in the format :

'Firstname Surname'

Is there a way I could extract just the surname to a different cell?

try TextToColumns with space as delimiter.


Regards
Claus B.

 

[Claus Busch]

Hi again,

Am Fri, 31 Oct 2014 17:06:22 +0100 schrieb Claus Busch:

try TextToColumns with space as delimiter.

or try:
=LEFT(A1,FIND(" ",A1)-1)


Regards
Claus B.

 

[Vidcapper]

Hi again,

Am Fri, 31 Oct 2014 17:06:22 +0100 schrieb Claus Busch:

can't believe I didn't think of that one!

or try:
=LEFT(A1,FIND(" ",A1)-1)

That extracts the firstname, it was the surname I was looking for.

Thanks for the help, as always.

 

[Claus Busch]

Hi Paul,

Am Fri, 31 Oct 2014 16:18:32 +0000 schrieb Vidcapper:

That extracts the firstname, it was the surname I was looking for.

sorry.
Try:
=MID(A1,FIND(" ",A1)+1,99)


Regards
Claus B.

 

[Claus Busch]

Hi,

Am Fri, 31 Oct 2014 17:20:46 +0100 schrieb Claus Busch:

=MID(A1,FIND(" ",A1)+1,99)

if there can be more than one firstname try:
=MID(A1,FIND("#",SUBSTITUTE(A1," ","#",LEN(A1)-LEN(SUBSTITUTE(A1," ",))))+1,99)


Regards
Claus B.

 

[Vidcapper]

Hi,

Am Fri, 31 Oct 2014 17:20:46 +0100 schrieb Claus Busch:


if there can be more than one firstname try:
=MID(A1,FIND("#",SUBSTITUTE(A1," ","#",LEN(A1)-LEN(SUBSTITUTE(A1," ",))))+1,99)

Thank you - the latter is ideal, as there are indeed more than one
forename in some cases.