#Value! Error with String Split Formula

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
 

Some videos you may like

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

pgc01

MrExcel MVP
Joined
Apr 25, 2006
Messages
19,873
Hi Joe
Welcomr to the board

Try:

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

Hope this helps
PGC
 

Watch MrExcel Video

Forum statistics

Threads
1,118,889
Messages
5,574,846
Members
412,620
Latest member
sharma7s
Top