Hi all,
I seem to get the FIND formula working only when I reference to a cell with the text I want to find.
When I try to use it this way:
=find(xxxxx,within_text destination)
or
=find('xxxxx',within_text destination)
I get errors.
It seems reasonable that you could do it without referencing a cell, but how?
So, just curious - can it be done and if so how?
Thanks
You refer to Mike Garvin's Excel Magic Trick 520.
If a forummember want to look at it, they have to google for that file.
Maybe you can post an link in your question.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
I didn't post it because it's not essential for the question......... just wanted to reference the master
good point though
http://www.youtube.com/watch?v=2R2OYJbKHlA
Hi, ANS,
did you try using quotes?
Formula:
Please Login or Register to view this content.
where I assumed that within_text_destination is a named range of a single cell. And I would suggest using an error handling in case no match is found as well.
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Hi,
thanks for the reply!
Yes, regular and double quotes. No go.
This will work:
=FIND("can","where can I find an icecream shop") The result is 7
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
If you use SEARCH instead of FIND you won't run into errors caused by the case of the letters. SEARCH isn't case sensitive while FIND is.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Some excel wiz has probably figured a way around this, but generally speaking, FIND/SEARCH is used to find text/numeric in a specific string, and then to return the position withIN that string where the search criteria begins - it is based on a string (read cell) not a range.
A1 = 123456 =FIND(345,D3,1) answer is 3
A1 = abcdef =FIND("cde",D3,1) answer is 3
A1 = abcdef =FIND("CDE",D3,1) answer is #VALUE! (because find is cap-sensitive)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thank you
Thnk you
Thanks for your explanation
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks