| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find & replace a value in an unknown cell location
Is there a function I can use to find a text string in a particular column -
say in column (H) for string 'Mytotal' to be replaced by 'Subtotal' when the cell location of 'Mytotal' is unknown only the column is known? And also is there a function that can find a certain value in a column then delete the row below the found value? e.g in column (H) find 'Subtotal' then delete the row below the occurance of 'Subtotal'. Help is much appreciated with this one? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find and replace does not work in a linked cell | Excel Discussion (Misc queries) | |||
| Find the cell value in excel by using vb code | Excel Discussion (Misc queries) | |||
| How can I do a find and replace for a cell that has multiple line. | Excel Discussion (Misc queries) | |||
| How do I find the contents of a cell using the "ADDRESS" function. | Excel Worksheet Functions | |||
| find replace ??* | Excel Worksheet Functions | |||
Threaded Mode
