Find

Shona · Apr 16, 2004

Hi

I think this is a mid find function but can't quite work it out.

I have a list of names eg John Smith in a cell I want to list the surnames
only.

Hope you can help

Thanks
Shona

Andy B · Apr 16, 2004

Hi

It is a mid function - you're right!
Try:
=MID(A1,FIND(" ",A1)+1,99)

Shona · Apr 16, 2004

That's great thanks

Shona

Andy B said:
Hi

It is a mid function - you're right!
Try:
=MID(A1,FIND(" ",A1)+1,99)

Andy B · Apr 16, 2004

Thanks for the feedback.

--
Andy.

Shona said:
That's great thanks

Shona