Excell Formula

[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 !

 

[Max]

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

 

[StpNs]

Another

=Proper(A2)&Upper(Left(B2))&"08"

Hope this helps.

 

[Max]

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
---

 

[KW2K]

Hi Max,
Thanks for the Reply, Thanks to your post I have now got it working ok.
Many Thanks !

 

[Max]

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