edited tags

Link

edited May 29, 2019 at 8:11

Applied code formatting, deleted a duplicate word.

Source Link

edited Oct 2, 2016 at 5:06

I have one cell that contains a long string of several values separated by "|".

EXAMPLE in Cell B5

title | time | location | cost

title | time | location | cost

I need a formula that will show the value of B5, but only the characters before the first "|".

Is Is it possible to trim everything including and following a specific character?

I have one cell that contains a long string of several values separated by "|".

EXAMPLE in Cell B5

title | time | location | cost

I need a formula that will show the value of B5, but only the characters before the first "|".

Is Is it possible to trim everything including and following a specific character?

I have one cell that contains a long string of several values separated by "|".

EXAMPLE in Cell B5

title | time | location | cost

I 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?

Source Link

asked Sep 30, 2016 at 1:13

Drop part of a cell value after a specific character

I have one cell that contains a long string of several values separated by "|".

EXAMPLE in Cell B5

title | time | location | cost

I need a formula that will show the value of B5, but only the characters before the first "|".

Is Is it possible to trim everything including and following a specific character?

google-sheets formulas

Return to Question