#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
excell formula can any one help TheHilife Excel Discussion (Misc queries) 3 June 23rd 07 12:31 PM
Excell convert formula row to formula column **Danny** Excel Worksheet Functions 1 January 14th 07 11:03 PM
Excell Formula Riece Excel Discussion (Misc queries) 1 October 16th 06 06:58 PM
formula - excell Corinna Excel Worksheet Functions 1 July 16th 06 12:03 PM
Formula in Excell naflan Excel Worksheet Functions 2 December 27th 05 04:15 PM


All times are GMT +1. The time now is 01:53 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"