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/