Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Capitalisation of First Letter in Name
Hello, could someone please help with the following:
in column C of my workbook, I need an algorithm that makes the first letter in the First Name in upper-case and the first letter in the Last Name in upper-case. Example: john green becomes John Green The letters after the upper-case letter need to remain in lower-case as shown in the example above. Both the First name and Last name are in column C. Any help is greatly appreciated, Cheers, Chris. *** Sent via Developersdex http://www.developersdex.com *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Capitalisation of First Letter in Name
Look at the Proper worksheet function, eg place the following in col-D
=Proper(C1) Correct any names that are still not right, when done pasteSpecial values back to Col-C Regards, Peter T "Chris" wrote in message ... Hello, could someone please help with the following: in column C of my workbook, I need an algorithm that makes the first letter in the First Name in upper-case and the first letter in the Last Name in upper-case. Example: john green becomes John Green The letters after the upper-case letter need to remain in lower-case as shown in the example above. Both the First name and Last name are in column C. Any help is greatly appreciated, Cheers, Chris. *** Sent via Developersdex http://www.developersdex.com *** |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Capitalisation of First Letter in Name
=PROPER(C1)
-- Kind regards, Niek Otten Microsoft MVP - Excel "Chris" wrote in message ... Hello, could someone please help with the following: in column C of my workbook, I need an algorithm that makes the first letter in the First Name in upper-case and the first letter in the Last Name in upper-case. Example: john green becomes John Green The letters after the upper-case letter need to remain in lower-case as shown in the example above. Both the First name and Last name are in column C. Any help is greatly appreciated, Cheers, Chris. *** Sent via Developersdex http://www.developersdex.com *** |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Capitalisation of First Letter in Name
thanks Peter T, your function works a treat - very much appreciated
*** Sent via Developersdex http://www.developersdex.com *** |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Capitalisation of First Letter in Name
thanks Niek Otten, your function works well - very much appreciated.
*** Sent via Developersdex http://www.developersdex.com *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mortgage with Quarterly Capitalisation & Monthly Payments | Excel Worksheet Functions | |||
New Validation option to format 1st letter as Capital letter | Excel Discussion (Misc queries) | |||
3 letter capitalisation | Excel Discussion (Misc queries) | |||
column header changed from letter to number, how return to letter | Excel Discussion (Misc queries) | |||
press letter and go 2 entry begin w letter in data validation drop | Excel Programming |