LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 60
Default 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 ***
 
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
Mortgage with Quarterly Capitalisation & Monthly Payments Beth Excel Worksheet Functions 8 December 3rd 08 12:09 PM
New Validation option to format 1st letter as Capital letter Jeff Excel Discussion (Misc queries) 5 July 13th 06 05:11 AM
3 letter capitalisation Voodoodan Excel Discussion (Misc queries) 8 January 27th 06 03:13 PM
column header changed from letter to number, how return to letter Ron Excel Discussion (Misc queries) 2 May 9th 05 08:34 PM
press letter and go 2 entry begin w letter in data validation drop MCP Excel Programming 1 August 28th 04 05:07 PM


All times are GMT +1. The time now is 11:58 AM.

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

About Us

"It's about Microsoft Excel"