#Value! Error with String Split Formula

[joseph.ekdahl]

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

 

[pgc01]

Hi Joe
Welcomr to the board

Try:

=IF(AS5="","",LEFT(AS5,FIND(";",AS5,1)-1))

Hope this helps
PGC

 

[joseph.ekdahl]

That worked like a charm - thanks a million for the fast reply!

Joe

 

[barry houdini]

Here's another way

=LEFT(AS5,FIND(";",AS5&";")-1)