Excel 2007 replace

[Jim WV]

Advance warning, this is a rant, and I apologize in advance since I know there are some really great users/contributors in here.



I simply cannot believe that a simple replace (blank cell with a 0) operation that worked wonderfully in prior versions chokes in Excel XP 2007! I know there is probably a work around that works, and that I have found before but I can't remember now, but for the L.O.G. and for all that is holy, why . Tell me the workaround and I will be happy with that, but my beef remains!

I have used Excel/Word/Access for close to 15 years and consider myself somewhat of an expert, IMO. When I'm in full swing I daresay it is difficult for any processor to keep up with me, and now in major analysis mode I'm all PO. I'll try and take a deep breath and export Access query as text and work from there, sigh.

Thanks for listening, I feel better now, and have a great day!

Despite my rant I have advanced greatly in my field via Access to Excel to analysis programs such as R. I am suitable grateful to these powerful programs, since I can remember 5 1/4 floppies. Are the newer versions of Excel subject to this?

Jim
Very Frustrated Yet Grateful
WVU
Morgantown
WV

[Colin Legg]

Um.... welcome to the forum, Jim.

I just did a find/replace empty cell / 0 without a problem in XL 2010. I've got XL 2007 kicking around so I can test on that version too but, before I do, can you give me a step by step breakdown of what you're doing and what's going wrong for you?

[Jim WV]

Thanks, its a find-replace operation after I select a big range of cells (e.g., 100 column x 1,000 row). It's like lightning in excel 2003, but I can actually observe how slowly it works in 2007. I believe it has something to do with formatting of cells. Noticed slowness in running a search-replace macro I wrote for 03, too.

I'm over my rant, sorry for the melodrama.
Regards
Jim

Originally Posted by Colin Legg

Um.... welcome to the forum, Jim.

I just did a find/replace empty cell / 0 without a problem in XL 2010. I've got XL 2007 kicking around so I can test on that version too but, before I do, can you give me a step by step breakdown of what you're doing and what's going wrong for you?