| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find First Non blank cell than find column header and return that value | Excel Worksheet Functions | |||
| Despite data existing in Excel 2002 spreadsheet Find doesn't find | Excel Discussion (Misc queries) | |||
| find and delete duplicate entries in two columns or find and prin. | Excel Programming | |||
| find and delete text, find a 10-digit number and put it in a textbox | Excel Programming | |||
| backwards find function to find character in a string of text | Excel Programming | |||
![Painter[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
