markjarvisltd
Board Regular
- Joined
- Sep 17, 2004
- Messages
- 92
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!
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!