Question

How do you extract text from a cell before character in Excel?

Answer 1

To extract text from a cell before a specific character in Excel, use the LEFT function along with the FIND function.

Step-by-step explanation:

To extract text from a cell before a specific character in Excel, you can use the LEFT function along with the FIND function. To extract text from a cell before a specific character in Excel, use the LEFT function along with the FIND function. The LEFT function returns a specified number of characters from the start of a text string, while the FIND function locates the position of a text string within another text string. Here's an example:

=LEFT(A1, FIND("-", A1)-1)

This formula extracts all the characters before the first hyphen (-) in cell A1.