On Fri, 23 Jan 2009 23:07:42 -0800 (PST), wrote:

Hello All,
I am using Office 2003 and have the following problem for eg.

Col A – Heading is User Name = JOHN.EMBUREY (first name is JOHN and
second name is EMBUREY)
Col B – Heading is Computer Name = should show first 3 characters of
second name and first two characters of the first name plus 01 and LT

Col B = In the above example would be EMBJO01LT

Obviously the number of characters in first name and second name will
vary.

I need a formula which should look up first 3 characters of the last
name i.e. after the period (.) and first two characters of the first
name i.e beginning two characters concatenated with 01LT.

Any help would be appreciated.


TIA

Rashid Khan


Try this formula in cell B1

=MID(A1,FIND(A1,".")+1,3)&LEFT(A1,2)&"01LT"

Hope this helps / Lars-Åke