#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

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

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,193
Messages
5,570,783
Members
412,340
Latest member
nikitesh95
Top