Iserror more than once

[markjarvisltd]

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!

 

[Norie]

mark

Can you post some sample data and expected results?

 

[markjarvisltd]

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

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

 

[markjarvisltd]

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