Create a helper column next to your column.
If your data is in column A starting in A1, put =Proper(A1) in B1 and copy
it down. Then, copy the new cells and go to Edit | Paste Special | Values.
Then, delete the original column.
tj
"Harvey" wrote:
In a spreadsheet that I made, there is a column with all types of text: all
upper, all lower, proper. It could be a long task to re-type each cell.
I'd like to convert this entire column to all proper. How can this be easily
done?
Thanks in advance for your help.
|