Learning how to use excel 2010 and dont know how to capitalize the first letter of a proper name. Any help would be appreciated... thank you
Learning how to use excel 2010 and dont know how to capitalize the first letter of a proper name. Any help would be appreciated... thank you
Hello & Welcome to the Board,
You can use the worksheet function...
=Proper(A1)
With A1 holding the name
You can also use
=Lower(A1) and =Upper(A1) to do what the names express
HTH
Regards, Jeff
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks