Posted to microsoft.public.excel.misc

external usenet poster

Posts: 1,670

How to search for text?

Does anyone have any suggestions on how to search for text?
For example, Apple (93) in cell A1,
I would like to search for any text including Apple in cell A1,
It should return True in cell B1, because the text Apple is included in cell
A1.
Does anyone have any suggestions?
Thank you very much
Eric

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
Fun with text functions - search for text	mr tom	Excel Worksheet Functions	7	October 26th 07 07:17 PM
Search, find or lookup defined text in text string	zzxxcc	Excel Worksheet Functions	9	September 6th 07 09:37 PM
Search in a text box	Michael R	Excel Discussion (Misc queries)	0	February 22nd 07 03:28 PM
Search text	lashio	Excel Discussion (Misc queries)	4	May 30th 05 02:50 PM
Text search	Elizabeth	Excel Discussion (Misc queries)	2	April 27th 05 05:57 PM

All times are GMT +1. The time now is 03:36 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us