ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Find/Rplace (https://www.excelbanter.com/excel-programming/351987-find-rplace.html)

Painter[_2_]

Find/Rplace
 
I am trying to find a range of Numeric values i.e. .25 to 100 and
replace it with a single Text character such as (*) . The find field
does not seem to be able to deal with a range of numbers.

If anyone has a solution please let me know.

Painter


Lenny

Find/Rplace
 
Try highlighting the colum you want to find the values in click data filter
autofilter
you will now see and arrow at the top this will list
you could always sort numericly above filter

"Painter" wrote:

I am trying to find a range of Numeric values i.e. .25 to 100 and
replace it with a single Text character such as (*) . The find field
does not seem to be able to deal with a range of numbers.

If anyone has a solution please let me know.

Painter




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

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