Find

  • Thread starter Thread starter Shona
  • Start date Start date
S

Shona

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
 
Hi

It is a mid function - you're right!
Try:
=MID(A1,FIND(" ",A1)+1,99)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Comparing two columns 1
simple question about excel 5
Seperating Text in One Field into 2 Fields EG FullName 1
Reversing the position of people's names in a cell 8
swop round data in a cell 3
Search and copy certain text 2
(Please Help) Merge coloms based on equal rows with information 1
Trim a cell that has names and address to only show name 8

Back
Top