In sharepoint list i want to create a column which contain First name of multiple person

[aqeel_shaikh]

Hi community, I need help here

In sharepoint list i want to create a column "FirstName" which contain First name of multiple person from another field which has Full name 

eg. "John Mathew"  & "Andrew Sam Mathew" requirement in First Name "John M" & Andrew S"

please assist and i want to create this in sharepoint list.

thanks

[arvindsingh802 · Accepted solution]

For Sharepoint related query qould suggest to post in Sharepoint community
Also one of the similar post https://techcommunity.microsoft.com/discussions/sharepoint_general/sharepoint-calculated-column-comb... 
In your case you can use formula =LEFT([Full name],(Find(" ",[Full name])+1))