Formula for Computer Names

[prkhan56]

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

 

[FSt1]

hi.
try something like this....
=MID(A2,FIND(".",A2,1),4)&LEFT(A2,2)&"01LT"

worked on your example in xp....on friday.
Regards
FSt1

 

[Lars-Åke Aspelin]

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

 

[prkhan56]

Try this formula in cell B1

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

Hope this helps / Lars-Åke- Hide quoted text -

- Show quoted text -

It shows #Value error

 

[prkhan56]

hi.
try something like this....
=MID(A2,FIND(".",A2,1),4)&LEFT(A2,2)&"01LT"

worked on your example in xp....on friday.
Regards
FSt1










- Show quoted text -

It works but with a period in the beginning.
Any clues?
Thanks

 

[Lars-Åke Aspelin]

It shows #Value error

Sorry, I mixed up the arguments.
Try this instead

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

Lars-Åke

 

[prkhan56]

Sorry, I mixed up the arguments.
Try this instead

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

Lars-Åke- Hide quoted text -

- Show quoted text -

Works ok now.
Thanks a lot