#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8
Default Find and replace

Is there a way to break out of a Find and Replace procedure that is looking
for a link that it cannot find. I had an instance where I did find all and
noted that there were 388 cells that included what I asked to be replaced.
Then I made the mistake of clicking Replace All and found that I had set a
loop going where the system was looking for a non-existent link and I could
not break out of and had to hit return in respect each instance

Is there a way of braking out of that?

TIA
Ron
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 23
Default Find and replace

I don't know of a way to break out of this, but there is a way to avoid it
that I use. After filling out the "find what" and "replace with" boxes,
check "find next" and "replace" two or three times to see if it's working
correctly. Only then do I click "replace all."

"Ron McCormick" wrote in message
...
Is there a way to break out of a Find and Replace procedure that is
looking
for a link that it cannot find. I had an instance where I did find all
and
noted that there were 388 cells that included what I asked to be replaced.
Then I made the mistake of clicking Replace All and found that I had set a
loop going where the system was looking for a non-existent link and I
could
not break out of and had to hit return in respect each instance

Is there a way of braking out of that?

TIA
Ron



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8
Default Find and replace

Thanks Richard,

I was wondering if anyone knew if there was another way. I all too often
forget to a trial replace before setting the replace all

"Ron McCormick" wrote:

Is there a way to break out of a Find and Replace procedure that is looking
for a link that it cannot find. I had an instance where I did find all and
noted that there were 388 cells that included what I asked to be replaced.
Then I made the mistake of clicking Replace All and found that I had set a
loop going where the system was looking for a non-existent link and I could
not break out of and had to hit return in respect each instance

Is there a way of braking out of that?

TIA
Ron

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
where to put results of find operation in find and replace functio DEP Excel Worksheet Functions 5 November 15th 06 07:52 PM
find and replace - replace data in rows to separated by commas msdker Excel Worksheet Functions 1 April 15th 06 01:00 AM
Find and Replace blakrapter Excel Worksheet Functions 3 December 15th 05 12:25 AM
Find then If then Replace cisq1 Excel Worksheet Functions 2 July 10th 05 08:19 PM
find replace cursor default to find box luffa Excel Discussion (Misc queries) 0 February 3rd 05 12:11 AM


All times are GMT +1. The time now is 12:09 AM.

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

About Us

"It's about Microsoft Excel"