Excel formulas RIGHT, LEFT, TRIM????

I need help with a formula. I have a cell that contains an employee id and name (i.e. 1234 Tom Smith). I need a formula so that only Smith, Tom appears. Please help!

Answer
Answer

Let's say you have ID + name in A2.

=MID(A2,FIND(" ",A2,FIND(" ",A2)+1)+1,255)&","&MID(A2,FIND(" ",A2),FIND(" ",A2,FIND(" ",A2)+1)-FIND(" ",A2))

This can be filled down.

You can also use Flash Fill:

  • Enter Smith, Tom in the cell next to the ID + name.

  • Start doing the same in the row below, using the next name.

  • Excel should suggest filling in the rest for you.

---
Best wishes, HansV
https://www.eileenslounge.com

1 person found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info


Last updated March 30, 2025 Views 631 Applies to: