I have a spreadsheet with multiple total lines. I'm looking for a function to remove the word "total" from a cell. I have tried a function like this =LEFT(A1, FIND(" ", A1)-1) but if there is only one word, I get an error. If I try to use ISError, I just get true or false.
What am I missing? I'm using Excel 2000 which may make a difference in the formula.