Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
shoiley
 
Posts: n/a
Default 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

  #2   Report Post  
tjtjjtjt
 
Posts: n/a
Default

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

  #5   Report Post  
shoiley
 
Posts: n/a
Default

Thank you - I will try your suggestions.



  #6   Report Post  
shoiley
 
Posts: n/a
Default

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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
To safety merge cells without data destroyed, and smart unmerge! Kevin Excel Discussion (Misc queries) 0 December 30th 04 08:17 AM
Heps to design Locked/Unlocked cells in protected worksheet Kevin Excel Discussion (Misc queries) 0 December 30th 04 08:09 AM
Convert data of cells to any type: Number, Date&Time, Text Kevin Excel Discussion (Misc queries) 0 December 30th 04 07:55 AM
Count number of shaded cells Maddoktor Excel Discussion (Misc queries) 2 December 20th 04 09:35 PM
Chart disappears when source data cells are hidden Disappearing charts Excel Discussion (Misc queries) 2 December 5th 04 04:24 AM


All times are GMT +1. The time now is 12:01 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"