View Single Post
  #4   Report Post  
tjtjjtjt
 
Posts: n/a
Default

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.