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

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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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 ***

=PROPER(C1)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Chris" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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 ***

thanks Peter T, your function works a treat - very much appreciated



*** Sent via Developersdex http://www.developersdex.com ***

thanks Niek Otten, your function works well - very much appreciated.



*** Sent via Developersdex http://www.developersdex.com ***