Excel: How to get the first name and last name from a range that contains multiple splitter

I want to split a cell value using Excel Formula into FirstName and lastName but the name in the cell to be split is seperatef from multiple ways.

I need to use a single formula to split values. For reference, see attached screenshot.

  Sachin Yadav

Looks very much doable with a single formula. Can you share couple of examples with the required result.

Can not see the screenshot, there asking for more details.

  Asheesh Mattoo       18 Jul 2016       0       0     

Post Your Answers:

Please use the CODE HIGHLIGHT Button to format/highlight your codes if any