Hi
for SharePoint online the following examples might work for you as well:
result:
Calculated column FIRST
=TRIM(MID(FullName,1,FIND(", ",FullName,1)-1))
- Start at position one from FullName
- end at position
- where the following string is found in column FullName , starting at position 1: ", "
- Minus 1
- Trim the result
Calculated column LastName
=TRIM(RIGHT(FullName,LEN(FullName)-FIND(", ",FullName,1)))
- Get right from Fullname
- starting at
- Length of FullName
- minus position of string ", " within FullName
-- starting to look from 1st position within FullName - Trim the result