Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Query replace by VBA
Hi all,
I have 5x cells with the formula like VLOOKUP(B3,PNOA!A:Z, 4, FALSE) / 1000 How can I do query replace the 4 by other value, say 10, for cell having the similar formula? To be precise, I wonder how can I replac the 4 without using functions like left(), right()? Thanks in advance -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Query replace by VBA
Use search and replace.
Press CTRL-H, enter ",4," in the"Find what" box and ",10," in the "replace with" box. "kaon " wrote in message ... Hi all, I have 5x cells with the formula like VLOOKUP(B3,PNOA!A:Z, 4, FALSE) / 1000 How can I do query replace the 4 by other value, say 10, for cells having the similar formula? To be precise, I wonder how can I replace the 4 without using functions like left(), right()? Thanks in advance. --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Query replace by VBA
Select the cells that contain the formula. If they are not together
you can select as big a group as you want to include them all as lon as the ones you don't want changed to not contain an identical searc string. then do Edit=Replace Replace What: 4, FALSE) Replace with: 10, FALSE) Do you formulas really have spaces in them. If so, place them in th search strings so it is an exact match. Anyway, you want to get unique "target" so you don't change things you don't want changed. Leave Find Entire Cells Only unchecked and use Match Case a appropriate. So no code required. -- Regards, Tom Ogilv -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find/Replace External Data Web Query | Excel Worksheet Functions | |||
Replace ^ in web query result | Excel Worksheet Functions | |||
How to Delete a Range in Closed Workbook (to Replace Delete Query) | Excel Discussion (Misc queries) | |||
Replace with result of database query, instead of inserting | Excel Programming | |||
Replace ActiveCell w/Query Results? | Excel Programming |