#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

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

pgc01

MrExcel MVP
Joined
Apr 25, 2006
Messages
19,870
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,113,793
Messages
5,544,315
Members
410,602
Latest member
lidovi
Top