I have one cell that contains a long string of several values separated by  |. EXAMPLE in Cell B5title | time | location | costI need a formula that will show the value of B5, but only the characters before the first |.Is it possible to trim everything including and following a specific character? 
Drop part of a cell value after a specific character
google spreadsheets;formulas
I need a formula that will show the value of B5, but only the characters before the first |.=TRIM(LEFT(B5,SEARCH(|,B5)-1)The result is title