Extract data from a cell before a comma ...

Hello,

I know the RIGHT and LEFT formulas to extract and copy the first or last data from a cell.
But I'm looking for the formula to extract the data from the beginning of the cell up to the following comma or possibly a slash.

Configuration: Windows / Chrome 52.0.2743.116

8 answers

  • Votes
  • Date
  • Descending date
  1. Contributor
    Hello

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

    and if you want to convert the result to a number:

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

    thx

    --
    The quality of the answer mainly depends on the clarity of the question, thank you!