LinkBack URL
About LinkBacks
Hi
I am wanting to search a string of text (column A) for a name (column C), ideally a formula to search for two words (forename & surname) as they may be a middle initial on some records.
Regards
David
Hi
I am wanting to search a string of text (column A) for a name (column C), ideally a formula to search for two words (forename & surname) as they may be a middle initial on some records.
Regards
David
@MeDaveT,
Using your example file, in cell D1 and copied down:
=IFERROR(INDEX($A$1:$A$8,MATCH(1,INDEX(ISNUMBER(SEARCH(TRIM(LEFT(SUBSTITUTE(C1," ",REPT(" ",99)),99)),$A$1:$A$8))*ISNUMBER(SEARCH(TRIM(RIGHT(SUBSTITUTE(C1," ",REPT(" ",99)),99)),$A$1:$A$8)),),0)),"")
Does that work for you?
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Kind of, however I would like the UK/LONDON/OFFICE/ etc not to show on the result
What result are you looking for then? Just the name that it found?
Thinking about it the response I get should do the trick, thanks for your help
You're very welcome
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks