#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

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

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,861
Messages
5,574,703
Members
412,612
Latest member
Shotokan
Top