Hi Rich,

I thought ALL the text was in one cell (e.g. A1)..
if the number is in the next cell (B1)..

Go with:

=UPPER(LEFT(A1,2)&MID(A1,SEARCH(" ",A1,3)+1,2)&LEFT(B1,2))

-Steve

__________________
Hardcore Programming Solutions and Coffee Drinker