For my test, I used the formula on this data  below, which is all run
together in one cell. I found my mistake, had .RIB in my formula in
caps, oops! However I have found that in some of my data .rib IS in
caps - .RIB, so I guess I'll need to get this uniform before I run the
Find function.

The FIND function did a nice job and returned the info in the middle  -
john.smith@... -which is great! But I still need the SMTP: at
the beginning and .rib at the end.

SMTP:john.smith@...%
400:c=US;a=DMS;o=OK2;s=Smith;g=John;i=W;ou1=HKNN1;%
MS:SILLMAIL/SILLPOX1/smithjb%CCMAIL:smith, john at SILL