![]() |
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 |
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