Capitize first letter in sequence

[dberger16]

Hi,

here is an example of data in my column:

Lorena & james

i simply want to capitize the J (james).

Thanks for your assistance

DaveB
(e-mail address removed)

 

[Pete_UK]

Use the PROPER function:

=PROPER(A1)

Hope this helps.

Pete

 

[Max]

PROPER should do it ..

Assuming data in A1 down, eg:

Lorena & james

In B1, copied down: =PROPER(TRIM(A1))