How to find from "Find and Replace" command formula generated number? Sample file is also attached herewith. Your suggestion will be highly appreciated. Thank you.
Indra
How to find from "Find and Replace" command formula generated number? Sample file is also attached herewith. Your suggestion will be highly appreciated. Thank you.
Indra
Last edited by Indra Rai; 02-25-2012 at 06:45 AM.
Make sure you have the Look In option set to Value rather than Formula.
HI Indra,
Find and Replace window -> Options-> Look in -> Values.
Just change the preference as above and try again. Thanks.
Regards,
DILIPandey
<click on below 'star' if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), dilipandey@gmail.com
It's working. Thank you very much Andi Pope and Dilipandey for you prompt response.
Indra
You are welcome Indra...!!
Cheers
Regards,
DILIPandey
<click on below 'star' if this helps>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks