Thanks for the reply. Yes, I am sure that I can just use a formula using the terms MID, LEFT, TRIM etc. However, there's the rub. I am not able to figure out the exact formula. If you could relate the exact formula I would be very grateful.
You could also break this formula up into more than one cell in other ways, but the error check is my personal preference.
If you do not need the extreme flexibility of this solution, maybe the one Norie posted would suffice for you. Remember, if you only drive a Volvo, there's no (practical) need to gear it up as a Rolls Royce. Unless you are from Texas and like everything big. (j/k)