Thanks again! This helps me out quite a bit.

"Aladin Akyurek" wrote in
message ...

Dan Wrote:
... However,
the solution you provided did not quite produce an accurate result.
Your
solution seemed to resolve for the DL360 models, using the LEFT and 5
arguments, but not for the other models. ...

Really? The only thing you did different is applying LEFT() to all
models and taking out plusses.

Now, how would this be structured as one concise formula?

Just return to what I suggested with LEFT() added everywhere or take a
look at the suggestion Daniel M. makes.


--
Aladin Akyurek
------------------------------------------------------------------------
Aladin Akyurek's Profile:
http://www.excelforum.com/member.php...fo&userid=4165
View this thread: http://www.excelforum.com/showthread...hreadid=275986