Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excell Formula
Hi !
I wonder if anyone knows the formula to carry out the following: I have a spreadsheet with three colums, the first one has a list of surnames, the second column has a list of first names and in the third column I want to have Surname followed by the first letter of the Firstname followed by 08, ie BrownC08. Where Brown is the Surname, C is the first letter of the Firstname and 08 is 2008. I would also like to know how to change the first letter of the surname and first letter of the firstname to Capital Latters. Thanks in advance ! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excell Formula
This might suffice
In B1: =UPPER(LEFT(A2))&MID(A2,2,99)&UPPER(LEFT(B2))&"08" Copy down -- Max Singapore http://savefile.com/projects/236895 Downloads:15,700 Files:353 Subscribers:53 xdemechanik --- "KW2K" wrote: Hi ! I wonder if anyone knows the formula to carry out the following: I have a spreadsheet with three colums, the first one has a list of surnames, the second column has a list of first names and in the third column I want to have Surname followed by the first letter of the Firstname followed by 08, ie BrownC08. Where Brown is the Surname, C is the first letter of the Firstname and 08 is 2008. I would also like to know how to change the first letter of the surname and first letter of the firstname to Capital Latters. Thanks in advance ! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excell Formula
Another
=Proper(A2)&Upper(Left(B2))&"08" Hope this helps. -- StpNs "KW2K" เขียน: Hi ! I wonder if anyone knows the formula to carry out the following: I have a spreadsheet with three colums, the first one has a list of surnames, the second column has a list of first names and in the third column I want to have Surname followed by the first letter of the Firstname followed by 08, ie BrownC08. Where Brown is the Surname, C is the first letter of the Firstname and 08 is 2008. I would also like to know how to change the first letter of the surname and first letter of the firstname to Capital Latters. Thanks in advance ! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excell Formula
In B1:
should read "In C2:" Data is assumed in A2:B2 -- Max Singapore http://savefile.com/projects/236895 Downloads:15,700 Files:353 Subscribers:53 xdemechanik --- |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excell Formula
Hi Max,
Thanks for the Reply, Thanks to your post I have now got it working ok. Many Thanks ! "Max" wrote: This might suffice In B1: =UPPER(LEFT(A2))&MID(A2,2,99)&UPPER(LEFT(B2))&"08" Copy down -- Max Singapore http://savefile.com/projects/236895 Downloads:15,700 Files:353 Subscribers:53 xdemechanik --- "KW2K" wrote: Hi ! I wonder if anyone knows the formula to carry out the following: I have a spreadsheet with three colums, the first one has a list of surnames, the second column has a list of first names and in the third column I want to have Surname followed by the first letter of the Firstname followed by 08, ie BrownC08. Where Brown is the Surname, C is the first letter of the Firstname and 08 is 2008. I would also like to know how to change the first letter of the surname and first letter of the firstname to Capital Latters. Thanks in advance ! |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excell Formula
Welcome, that's good to hear.
Thanks for feeding back -- Max Singapore http://savefile.com/projects/236895 Downloads:15,700 Files:353 Subscribers:53 xdemechanik --- "KW2K" wrote in message ... Hi Max, Thanks for the Reply, Thanks to your post I have now got it working ok. Many Thanks ! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excell formula can any one help | Excel Discussion (Misc queries) | |||
Excell convert formula row to formula column | Excel Worksheet Functions | |||
Excell Formula | Excel Discussion (Misc queries) | |||
formula - excell | Excel Worksheet Functions | |||
Formula in Excell | Excel Worksheet Functions |