joseph.ekdahl
New Member
- Joined
- Sep 21, 2006
- Messages
- 4
Hello,
I am trying to split the following string:
Targeted Calibration = Fail; Calibration Agree % = 50.0; Targeted Calibration Adj. Agree % = 100.0
I'm using the following formula:
=MID(AS5,1,FIND(";",AS5,1)-1) - which leaves me with "Targeted Calibration = Fail"
How can I write it so I don't get the #value! error if the cell is blank.
Thanks a hundred times!
Joe
I am trying to split the following string:
Targeted Calibration = Fail; Calibration Agree % = 50.0; Targeted Calibration Adj. Agree % = 100.0
I'm using the following formula:
=MID(AS5,1,FIND(";",AS5,1)-1) - which leaves me with "Targeted Calibration = Fail"
How can I write it so I don't get the #value! error if the cell is blank.
Thanks a hundred times!
Joe