jimmy2times
Board Regular
- Joined
- Aug 8, 2014
- Messages
- 69
Hi Everyone,
I am working on an exercise where I am extracting the middle name from a list of names by locating the space characters in the text string. There are some entries with middle names and some without middle names. When there is no middle name I want to replace the #value error with a zero length string. See the example below
<tbody>
</tbody>Obviously there is no middle name for Bob Harris.
The formula I am using is
=IF(ISERROR(A3),"",MID(A3,B3+1,C3-B3))
I am getting the correct result for John Paul Smith but want to return "" for Bob Harris.
Why am I still getting the #value! error?
Any help would be much appreciated!
Jimmy
I am working on an exercise where I am extracting the middle name from a list of names by locating the space characters in the text string. There are some entries with middle names and some without middle names. When there is no middle name I want to replace the #value error with a zero length string. See the example below
Sales Manager | First Space | Second Space | Len | First Name | Middle Name |
John Paul Smith | 5 | 10 | 15 | John | Paul |
Bob Harris | 4 | #VALUE! | 10 | Bob | #VALUE! |
<tbody>
</tbody>
The formula I am using is
=IF(ISERROR(A3),"",MID(A3,B3+1,C3-B3))
I am getting the correct result for John Paul Smith but want to return "" for Bob Harris.
Why am I still getting the #value! error?
Any help would be much appreciated!
Jimmy