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.
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.