Find Function

V

VickiMc

How do I find the contents of one cell that could be anywhere in the text of
a second cell?
 
P

Pete_UK

Like this:

=SEARCH(B1,A1)

A1 is the long string, B1 is the string you are looking. If it exists
in A1 the function returns a number - if not you get an error. Use
FIND instead of SEARCH if case is important.

Hope this helps.

Pete
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Regarding Word Add in on Office 365 0
Removing a repeated words 0
Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0
WordPad blocked content 2
Excel does not accept text format! 0
Text in note pane of "normal" display suddenly much larger 1
Macro to copy table of contents to a new doc 0
Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2

Top