function to get certain type of data from string excel code example
Example 1: excel get some char from string
LEFT(text, [num_chars])
Example 2: excel get after character
=LEFT(text,FIND(character,text)-1)
LEFT(text, [num_chars])
=LEFT(text,FIND(character,text)-1)