ExcelBanter - Find & Replace

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

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

- - Find & Replace (https://www.excelbanter.com/excel-worksheet-functions/197289-find-replace.html)

chiefwidmer

Find & Replace

Is it possible to replace the contents of an entire row if that row has a
cell which was found with the F & R function?

When using the F&R function it found 132 instances of the find criteria. I
would like to clear the contents of the entire row for all 132 matches.

NoodNutt

Find & Replace

G'day Chief

Try here

http://www.rondebruin.nl/find.htm

Read the section at the bottom for replace

HTH
Mark.

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