| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for Computer Names
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula for Computer Names
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 " 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula for Computer Names
|
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula for Computer Names
On Jan 24, 11:34*am, Lars-Åke Aspelin
wrote: 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- Hide quoted text - - Show quoted text - It shows #Value error |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula for Computer Names
On Jan 24, 11:32*am, FSt1 wrote:
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 " 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- Hide quoted text - - Show quoted text - It works but with a period in the beginning. Any clues? Thanks |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula for Computer Names
|
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula for Computer Names
On Jan 24, 12:27*pm, Lars-Åke Aspelin
wrote: On Sat, 24 Jan 2009 00:22:41 -0800 (PST), wrote: On Jan 24, 11:34*am, Lars-Åke Aspelin wrote: 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- Hide quoted text - - Show quoted text - 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- Hide quoted text - - Show quoted text - Works ok now. Thanks a lot |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| COPYING FORMULA CONTAINING NAMES/RELATIVE RANGE NAMES | Excel Discussion (Misc queries) | |||
| Formulaed cell response varies from computer to computer | Excel Discussion (Misc queries) | |||
| Display size difference- PC computer vs. Mac computer? | Excel Discussion (Misc queries) | |||
| How do I copy all Excel files from old computer to new computer? | Excel Discussion (Misc queries) | |||
| Autocomplete works with my home computer but not the office computer | Excel Discussion (Misc queries) | |||
Linear Mode
