how do I convert text in excel to 1st letter capital,only

J

jmfp

I seem to be unable to get the data function 'proper' to work on a
spreadsheet. I want to convert entries in cells so that the first letter is a
capital, and the rest are in lower case. Can anyone help, I have used the
help function on excel, but sem unable to get it to do what I require.
 
D

Don Guillett

what is it that you require that is not being done by using the
=proper()function?
 

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

Similar Threads

Dealing with the error: unable to filter on excel hc home school 0
Unwanted change to capital letter 1
Merging from an Excel file with graphics 1
Find rows that contain capital letter? 4
Improving Macro That Keeps First Letter 0
Providing only read/view permission of the email account to the user. (like Senior wants PS to only view his emails and not to respond or do action) 0
Excel does not accept text format! 0
How to disable Alt+s in Outlook 365 0

Top