Count cells with data
 

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

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

Try selecting the 1st celltouching the shift keyend key+down arrow

--
Don Guillett
SalesAid Software

"shoiley" wrote in message
...
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

Sub makeproper()
With ActiveSheet.UsedRange.SpecialCells(xlCellTypeConst ants)
..Value = Application.Proper(.Value)
End With
End Sub


--
Don Guillett
SalesAid Software

"Don Guillett" wrote in message
...
Try selecting the 1st celltouching the shift keyend key+down arrow

--
Don Guillett
SalesAid Software

"shoiley" wrote in message
...
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

Thank you - I will try your suggestions.

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

Thank you - I will try this.