Posted to microsoft.public.excel.misc

Chuck Neal

Posts: n/a

Dashes in my result

I have the following formula in cell D1.

=IF(A1=C1,B1," ")

It is possible that cells A1 and C1 could be blank. When that happens, the
formula returns a "-" in D1. Normally I would use the Autofilter and delete
these, however, I am using a macro and using the Autofilter slows it down to
a crawl. Is there a way (formula or otherwise), to eliminate the - in my
cell?
Thanks!

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
excel	melissa	Excel Worksheet Functions	2	August 19th 05 09:46 PM
I NEED HELP with the SPELLNUMBER Function	vag	Excel Worksheet Functions	0	June 21st 05 08:17 AM
EXCEL:NUMBER TO GREEK WORDS	vag	Excel Worksheet Functions	1	June 15th 05 05:57 PM
Amount or Numbers in Words	ron	New Users to Excel	6	December 24th 04 07:32 PM
Spellnumber	Norman Jones	Excel Worksheet Functions	6	December 13th 04 07:21 AM

All times are GMT +1. The time now is 05:13 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us