• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 272
  • Last Modified:

Excel 2000 error parsing text in cell

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.

12192
12192 Total
12514
12514 Total
900000
900000 Total
A1389099
A1389099 Total
0
minamina6
Asked:
minamina6
1 Solution
 
NBVCCommented:
Try:

=TRIM(SUBSTITUTE(A1,"Total",""))

or

=LEFT(A1, FIND(" ", A1&" ")-1)  if you only want first word, where other word might not be Total.
0
 
barry houdiniCommented:
Using your original approach but with a slight amendment....

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

regards, barry
0
 
minamina6Author Commented:
NB_VC,
Thanks for giving me two options. I can use the second one elsewhere.
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now