take out substring from string in 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)