excel formula to get the character before and after specific value the string code example Example: excel get after character =LEFT(text,FIND(character,text)-1)