Splitting Names

  • Thread starter Thread starter Vidcapper
  • Start date Start date
V

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.
 
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?
Click to expand...

try TextToColumns with space as delimiter.


Regards
Claus B.
 
Hi again,

Am Fri, 31 Oct 2014 17:06:22 +0100 schrieb Claus Busch:
try TextToColumns with space as delimiter.
Click to expand...

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


Regards
Claus B.
 
Hi again,

Am Fri, 31 Oct 2014 17:06:22 +0100 schrieb Claus Busch:
Click to expand...

can't believe I didn't think of that one! :p
or try:
=LEFT(A1,FIND(" ",A1)-1)
Click to expand...

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

Thanks for the help, as always. :)
 
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.
Click to expand...

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


Regards
Claus B.
 
Hi,

Am Fri, 31 Oct 2014 17:20:46 +0100 schrieb Claus Busch:
=MID(A1,FIND(" ",A1)+1,99)
Click to expand...

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


Regards
Claus B.
 
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)
Click to expand...

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