Forum Discussion

SteveMorley1's avatar
SteveMorley1
Brass Contributor
May 12, 2022
Solved

Help with an Excel formula with conditions based on a single text cell with multiple values

I have a column with multiple values possible in it.  I'm trying to extract the first word from each cell in the column.  As above, you can see I've got a formula for the condition if there are...
  • OliverScheurich's avatar
    May 12, 2022

    SteveMorley1 

    =IFERROR(LEFT(A2,FIND(" ",A2)-1),A2)

    Maybe with IFERROR in addition to your formula.