A SharePoint list contatins three columns,
- Requestor name (Single Line of Text)
- First name (Calculated column)
- Last Name (Calculated column)
I want to extract First Name and Last Name from the Reequestor Name. The Requestor Name might be in either of the below formats
Sachin Tendulkar or Sachin R Tendulkar
Sachin | Tendulkar First Name | Last Name Sachin | R | Tendulkar First Name | Middle Name | Last Name
In the First name column, am able to get the required result using below formula,
(LEFT( [Requester Name],INT(FIND(" ",[Requester Name])-1))
For Last name, I am running into issue here because of the inconsistency in the middle initial. My formula is
RIGHT([Calc Column Last Name],LEN([Calc Column Last Name])-INT(FIND(" ",[Calc Column Last Name])))
Doesnt like the fact that if there is a middle initial. If there is a middle initial, I get a #VALUE! error.
How can I just extract the last name?