Cell change

[gmazza76]

Good Evening,

Is there any formula I can use in Excel to change the 1st letter of a name and surname except by amending each one.

ie Gavin Mazza - gavin mazza

The system we use at work has started registering information differently and i have about 3 thousand names i need to change so it would be very helpful.

Many Thanks
Gavin

 

[danzon]

=LOWER(A1)

where name is in A1