ExcelBanter - Problems with find/replace function

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Problems with find/replace function (https://www.excelbanter.com/excel-worksheet-functions/109180-problems-find-replace-function.html)

BobS9895

Problems with find/replace function

I have 25 lines of information that have the word "steel" in the
formula. When I do a find "steel" and replace with "steel div" it only
replaces the first 15 lines. The remaining lines I get an error
message that says "That name is not valid".

So why is that name valid on the first 15 lines but not the remaining
lines?

Dave F

Problems with find/replace function

What formula are you using?
--
Brevity is the soul of wit.

"BobS9895" wrote:

I have 25 lines of information that have the word "steel" in the
formula. When I do a find "steel" and replace with "steel div" it only
replaces the first 15 lines. The remaining lines I get an error
message that says "That name is not valid".

So why is that name valid on the first 15 lines but not the remaining
lines?

All times are GMT +1. The time now is 03:31 AM.