You are using a second column to convert to Proper?
You can Double-Click the Fill Handle instead of Draging it, provided the
Columns are next to each other.

--or--

Identify the bottom cell in the Data (before using PROPER).
Then Press the [F5] Key.
Type A1:A5000 (where A1 is the first cell in the range to convert and A5000
is the last cell). Click Okay and the whole range will be selected.
Then, type: =PROPER(A1)
Press Ctrl+Enter

tj

"shoiley" wrote:

I receive large databases each month. I have been able to format the data
using PROPER. Though when I follow the instuctions from "3 formatting
shortcuts" it calls for dragging the fill handle to the end of the new column
to show all the converted cells. My databases are hundreds of names long!
Is there a way to count the cells with text in them in advance - without
scrolling down to the bottom - and then put the range into the =PROPER (range
of cells with data) command?
--
Thank you kindly