# Iserror more than once

#### markjarvisltd

##### Board Regular
Im completly befuddeled trying to use iserror several time to get the answers I need.
The first test looks for a ":" and returns as such =MID(A1,FIND(":",A1)-2,5).
The second test looks for a "," and returns such =MID(A1,FIND(",",A1)+2,1)&" "&LEFT(A1,FIND(",",A1)-1).
If any other value or fault is returned a blank cell is made blank.
Help in iserror would be apreciated and methords to keep sence of where you are with it!

### Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

#### Norie

##### Well-known Member
mark

Can you post some sample data and expected results?

#### markjarvisltd

##### Board Regular
Copy of Transition Sheet3.xls
ABCD
1Weekley/Clarke/GoosenPGAChampionship-1stRnd3Balls09Aug14:05Liveon14:05
2SelectionPrice
3Weekley,Boo15/8BWeekley
4Clarke,Darren9/4DClarke
5Goosen,Retief6/5RGoosen
6Olazabal/Funk/OberholserPGAChampionship-1stRnd3Balls09Aug14:10Liveon14:10
7SelectionPrice
8Olazabal,Jose-Maria9/4JOlazabal
9Funk,Fred7/4FFunk
10Oberholser,Arron5/4AOberholser
Sheet1

The a column is the imported data.
The b column on the first group is the intended return

#### markjarvisltd

##### Board Regular
Currently #value! is shown for selection price in my poor efforts!

Replies
15
Views
1K
Replies
11
Views
2K
Replies
1
Views
187
Replies
0
Views
325
Replies
1
Views
267

1,191,399
Messages
5,986,365
Members
440,020
Latest member
IfsandSums

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back