I tried to find and replace in only one column, but it worked on the whole
workbook. Is there a way to only find and replace on selected range. Thank
you in advance.

Ahhh. You're using xl2002 or xl2003.

And you did this:
selected your column
edit|replace
Then you clicked the Find All button.

That changed the selection to one cell.

So the next thing you did Replace All, thought you meant the whole worksheet
(since only one cell was selected).

Don't do that Find All or select the original range after you do it.

Am I close?



Mike Busch wrote:

I tried to find and replace in only one column, but it worked on the whole
workbook. Is there a way to only find and replace on selected range. Thank
you in advance.

--

Dave Peterson

OK that worked BUT, BUT there are 7995 records. Some time there are over
1000 in a range.

"Dave Peterson" wrote:

Ahhh. You're using xl2002 or xl2003.

And you did this:
selected your column
edit|replace
Then you clicked the Find All button.

That changed the selection to one cell.

So the next thing you did Replace All, thought you meant the whole worksheet
(since only one cell was selected).

Don't do that Find All or select the original range after you do it.

Am I close?



Mike Busch wrote:

I tried to find and replace in only one column, but it worked on the whole
workbook. Is there a way to only find and replace on selected range. Thank
you in advance.

--

Dave Peterson

Dave's point is simply this: DO NOT click on the Find All button. Use the
Replace All option instead. The number of occurrences is immaterial

"Mike Busch" wrote:

OK that worked BUT, BUT there are 7995 records. Some time there are over
1000 in a range.

"Dave Peterson" wrote:

Ahhh. You're using xl2002 or xl2003.

And you did this:
selected your column
edit|replace
Then you clicked the Find All button.

That changed the selection to one cell.

So the next thing you did Replace All, thought you meant the whole worksheet
(since only one cell was selected).

Don't do that Find All or select the original range after you do it.

Am I close?



Mike Busch wrote:

I tried to find and replace in only one column, but it worked on the whole
workbook. Is there a way to only find and replace on selected range. Thank
you in advance.

--

Dave Peterson

Thanks, that worked, sorry for being a "cement head" Hey hockey is back......


"Duke Carey" wrote:

Dave's point is simply this: DO NOT click on the Find All button. Use the
Replace All option instead. The number of occurrences is immaterial

"Mike Busch" wrote:

OK that worked BUT, BUT there are 7995 records. Some time there are over
1000 in a range.

"Dave Peterson" wrote:

Ahhh. You're using xl2002 or xl2003.

And you did this:
selected your column
edit|replace
Then you clicked the Find All button.

That changed the selection to one cell.

So the next thing you did Replace All, thought you meant the whole worksheet
(since only one cell was selected).

Don't do that Find All or select the original range after you do it.

Am I close?



Mike Busch wrote:

I tried to find and replace in only one column, but it worked on the whole
workbook. Is there a way to only find and replace on selected range. Thank
you in advance.

--

Dave Peterson