Posted to microsoft.public.excel,microsoft.public.excel.programming

Michael Kintner[_4_] Michael Kintner[_4_] is offline

external usenet poster

Posts: 5

HELP: Search a formula inside of a Cell

I am trying to compare some old spreadsheets and upgrade to the new and have
a case in try to determine if a value was added to a formula inside a cell.
So I would like to do a search/find on the contents of the FORMULA in the
cell.

Example: Cell A1 Contains a formula +F12+F34+F67

Is there a function that can search the formula? Example: FIND "F34" in
cell A1. Everything I can see so far you can only search the results, not
the formula.

Thank you in advance for your help!!!
Mike

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Search data inside column	SANTANDER	Excel Programming	3	October 25th 07 03:45 PM
Utilizing a Cell even with a Formula located inside it	Ahh, Excel's Tough	Excel Worksheet Functions	4	July 3rd 07 01:13 AM
using the name of a worksheet written in a cell, inside a formula	Using the name of a worksheet written in	Excel Worksheet Functions	2	March 6th 06 10:29 PM
Using a value from a cell inside a formula!	marsupilami	Excel Discussion (Misc queries)	5	August 24th 05 07:06 AM
Apparently Empty Cell--with formula inside	foamfollower	Excel Programming	1	March 4th 04 07:35 AM

All times are GMT +1. The time now is 10:09 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us