Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
multiple find and replace
I have a worksheet with long formulas pasted from a database. Some of these
ratios, i would like to replace. however, the sheet is 22,000 rows in length. I have around 350 ratios that I have in a seperate worksheet(column A), which I would like to replace with a different 350 ratios from the last mentioned sheet (column B). Therefore in 22,000 lines, I would like to replace 350 ratios inside this 22,000 lines, with another specific ratio, which is in a table. Tricky one |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
multiple find and replace
That would depend on what the ratios look like... you can do a Find/Replace,
but we'd need to know what you're replacing and where it would be. Could you provide one of the formulas in a post, along with a sample of a few lines from the new table? "Andre" wrote: I have a worksheet with long formulas pasted from a database. Some of these ratios, i would like to replace. however, the sheet is 22,000 rows in length. I have around 350 ratios that I have in a seperate worksheet(column A), which I would like to replace with a different 350 ratios from the last mentioned sheet (column B). Therefore in 22,000 lines, I would like to replace 350 ratios inside this 22,000 lines, with another specific ratio, which is in a table. Tricky one |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Tidy up multiple find and replace code | Excel Worksheet Functions | |||
Multiple find mulitple replace | Excel Worksheet Functions | |||
Find/Replace in multiple worksheets | Excel Discussion (Misc queries) | |||
Multiple Find and Replace in one function | Excel Worksheet Functions | |||
How can I do a find and replace for a cell that has multiple line. | Excel Discussion (Misc queries) |