ExcelBanter - FIND and REPLACE characters needed

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

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

- - FIND and REPLACE characters needed (https://www.excelbanter.com/excel-worksheet-functions/70444-find-replace-characters-needed.html)

Peter C

FIND and REPLACE characters needed

What characters (~, #, ?) do I use to Find and Replace item cells of first
following row with second row below?

FIND these types, eg: =(DSUM(DIVOH,$CX$1,$DG$2:$DG$20)

Replace with these types, eg:
=IF(ISERROR(DSUM(DIVOH,$CX$1,$DG$2:$DG$20)),0)

Thanks.
Peter C

All times are GMT +1. The time now is 02:04 AM.