ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How to replace ... with a 0 (https://www.excelbanter.com/excel-worksheet-functions/124983-how-replace-0-a.html)

Shannon Y

How to replace ... with a 0
 
How to replace (...) with a 0. what the quickest way for hundreds of cells

Corey

How to replace ... with a 0
 
Highlight entire sheetGrey Square above the 1 and to the left of A. then
EditReplace (...) with 0
REPLACE ALL

"Shannon Y" wrote in message
...
How to replace (...) with a 0. what the quickest way for hundreds of
cells





All times are GMT +1. The time now is 11:20 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com