Ufdjrw

Using dividends to reduce short term capital gains?

Word for: a synonym with a positive connotation?

Why are PDP-7-style microprogrammed instructions out of vogue?

How did the audience guess the pentatonic scale in Bobby McFerrin's presentation?

What is the padding with red substance inside of steak packaging?

Sub-subscripts in strings cause different spacings than subscripts

Single author papers against my advisor's will?

Identify 80s or 90s comics with ripped creatures (not dwarves)

Why did Peik Lin say, "I'm not an animal"?

What's the point in a preamp?

how can a perfect fourth interval be considered either consonant or dissonant?

Why not take a picture of a closer black hole?

Presidential Pardon

Example of compact Riemannian manifold with only one geodesic.

My body leaves; my core can stay

Is there a writing software that you can sort scenes like slides in PowerPoint?

Is this wall load bearing? Blueprints and photos attached

Could an empire control the whole planet with today's comunication methods?

What information about me do stores get via my credit card?

How to politely respond to generic emails requesting a PhD/job in my lab? Without wasting too much time

Does Parliament need to approve the new Brexit delay to 31 October 2019?

Can we generate random numbers using irrational numbers like π and e?

Accepted by European university, rejected by all American ones I applied to? Possible reasons?

What force causes entropy to increase?

Matching string where the string has wildcard character - Excel

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;

-2

I have a data in 2 columns.

Column A includes some text with no wildcard characters.

I want to see if the cells in Column A has specific strings. When I use search function, I can use "*" to refer to any number of numbers/letters. Hence I created column B with these strings, which include wildcard characters.

Here, I want to see if a cell in column A has the string in column B, with wildcard characters being satisfied as in the search function.

I hope it is clear.

P.S. A2 has the string in B1.

Thank you in advance for your help.
Aslihan.

excel search match wildcard

share|improve this question

edited Mar 8 at 12:37

JvdV

3,0271313

asked Mar 8 at 12:22

Aslıhan HilalAslıhan Hilal

1

add a comment | 

-2

I have a data in 2 columns.

Column A includes some text with no wildcard characters.

I want to see if the cells in Column A has specific strings. When I use search function, I can use "*" to refer to any number of numbers/letters. Hence I created column B with these strings, which include wildcard characters.

Here, I want to see if a cell in column A has the string in column B, with wildcard characters being satisfied as in the search function.

I hope it is clear.

P.S. A2 has the string in B1.

Thank you in advance for your help.
Aslihan.

excel search match wildcard

share|improve this question

edited Mar 8 at 12:37

JvdV

3,0271313

asked Mar 8 at 12:22

Aslıhan HilalAslıhan Hilal

1

add a comment | 

I have a data in 2 columns.

Column A includes some text with no wildcard characters.

I want to see if the cells in Column A has specific strings. When I use search function, I can use "*" to refer to any number of numbers/letters. Hence I created column B with these strings, which include wildcard characters.

Here, I want to see if a cell in column A has the string in column B, with wildcard characters being satisfied as in the search function.

I hope it is clear.

P.S. A2 has the string in B1.

Thank you in advance for your help.
Aslihan.

excel search match wildcard

share|improve this question

edited Mar 8 at 12:37

JvdV

3,0271313

asked Mar 8 at 12:22

Aslıhan HilalAslıhan Hilal

1

share|improve this question

edited Mar 8 at 12:37

JvdV

3,0271313

asked Mar 8 at 12:22

Aslıhan HilalAslıhan Hilal

1

share|improve this question

edited Mar 8 at 12:37

JvdV

3,0271313

asked Mar 8 at 12:22

Aslıhan HilalAslıhan Hilal

1

edited Mar 8 at 12:37

JvdV

3,0271313

edited Mar 8 at 12:37

JvdV

3,0271313

asked Mar 8 at 12:22

Aslıhan HilalAslıhan Hilal

1

asked Mar 8 at 12:22

Aslıhan HilalAslıhan Hilal

1

1 Answer
1

active

oldest

votes

0

I'm unsure what result you are looking for but your example could be used like so:

The formula comes down to: =MATCH("*"&..YOUR SEARCH VALUE..&"*",A:A,0)

Another way to tell that A2 has value from B1 could be:

Formula translates to: ="B"&AGGREGATE(15,3,((SEARCH($B$1:$B$3,A1)/(SEARCH($B$1:$B$3,A1))*ROW($B$1:$B$3))),1)

Put both formulas in cell C1 and drag down, I just added an =IFERROR in both cases

share|improve this answer

edited Mar 8 at 13:05

answered Mar 8 at 12:49

JvdVJvdV

3,0271313

add a comment | 

Your Answer

StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55063166%2fmatching-string-where-the-string-has-wildcard-character-excel%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

0

I'm unsure what result you are looking for but your example could be used like so:

The formula comes down to: =MATCH("*"&..YOUR SEARCH VALUE..&"*",A:A,0)

Another way to tell that A2 has value from B1 could be:

Formula translates to: ="B"&AGGREGATE(15,3,((SEARCH($B$1:$B$3,A1)/(SEARCH($B$1:$B$3,A1))*ROW($B$1:$B$3))),1)

Put both formulas in cell C1 and drag down, I just added an =IFERROR in both cases

share|improve this answer

edited Mar 8 at 13:05

answered Mar 8 at 12:49

JvdVJvdV

3,0271313

add a comment | 

0

I'm unsure what result you are looking for but your example could be used like so:

The formula comes down to: =MATCH("*"&..YOUR SEARCH VALUE..&"*",A:A,0)

Another way to tell that A2 has value from B1 could be:

Formula translates to: ="B"&AGGREGATE(15,3,((SEARCH($B$1:$B$3,A1)/(SEARCH($B$1:$B$3,A1))*ROW($B$1:$B$3))),1)

Put both formulas in cell C1 and drag down, I just added an =IFERROR in both cases

share|improve this answer

edited Mar 8 at 13:05

answered Mar 8 at 12:49

JvdVJvdV

3,0271313

add a comment | 

I'm unsure what result you are looking for but your example could be used like so:

The formula comes down to: =MATCH("*"&..YOUR SEARCH VALUE..&"*",A:A,0)

Another way to tell that A2 has value from B1 could be:

Formula translates to: ="B"&AGGREGATE(15,3,((SEARCH($B$1:$B$3,A1)/(SEARCH($B$1:$B$3,A1))*ROW($B$1:$B$3))),1)

Put both formulas in cell C1 and drag down, I just added an =IFERROR in both cases

share|improve this answer

edited Mar 8 at 13:05

answered Mar 8 at 12:49

JvdVJvdV

3,0271313

share|improve this answer

edited Mar 8 at 13:05

answered Mar 8 at 12:49

JvdVJvdV

3,0271313

answered Mar 8 at 12:49

JvdVJvdV

3,0271313

answered Mar 8 at 12:49

JvdVJvdV

3,0271313