Count cells with data

[Guest]

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?

 

[Guest]

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

 

[Don Guillett]

Try selecting the 1st cell>touching the shift key>end key+down arrow

 

[Don Guillett]

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


--
Don Guillett
SalesAid Software
(e-mail address removed)

Try selecting the 1st cell>touching the shift key>end key+down arrow

 

[Guest]

Thank you - I will try your suggestions.

 

[Guest]

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.