Capitalisation of First Letter in Name

C

Chris

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

Peter T

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top