Posted to microsoft.public.excel.worksheet.functions

Heliocracy Heliocracy is offline

external usenet poster

Posts: 29

Ignoring Cells with Only Spaces

I'm trying to use the COUNTA function, but I need it to ignore cells that
contain ONLY spaces. I don't want to ignore cells that merely begin or end
with a space, and I don't know how many spaces may be present in the cells I
do want to ignore. Can anyone please help?

Thanks,
Heliocracy

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Ignoring Formulas within cells	jimswinder	Excel Worksheet Functions	8	July 21st 06 02:52 PM
Ignoring Blank Cells	Reefaman	Excel Worksheet Functions	2	June 11th 06 05:43 PM
Ignoring highlighted cells	frustrated	Excel Worksheet Functions	14	December 15th 05 09:02 AM
Ignoring zero cells in IF statements	~Andy~	Excel Worksheet Functions	5	November 29th 05 02:20 PM
Ignoring empty cells	beeo	Excel Discussion (Misc queries)	3	September 8th 05 09:57 AM

All times are GMT +1. The time now is 01:16 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us