Filter Extract a text from excel sheet having similar values

0 votes

I have data in the cell in this format saved in the A column in Excel.

[Amber,Maria,Marian,Mar]

[Maria]

[Marian,Amber,Maria]

[Maria,Marian]

I want a filter for Maria and Marian.

How can I use some regex formula filtering Maria and Marian separately?

Jan 9 in Others by Kithuzzz
• 28,900 points
31 views

1 answer to this question.

0 votes
ISNUMBER(SEARCH("Maria,",SUBSTITUTE(A1:A4,"]",",")))

 shows TRUE if Maria is found and false if it would only be Marian, not Maria. 

enter image description here

answered Jan 9 by narikkadan
• 53,520 points

Related Questions In Others

0 votes
1 answer

Stop Excel from automatically converting certain text values to dates

I've discovered that getting the desired result ...READ MORE

answered Dec 29, 2022 in Others by narikkadan
• 53,520 points
52 views
0 votes
1 answer

Converting Textboxes Link and/or Formula to Values in a Copied Sheet using Excel VBA

Copy the values using Range and Value2 With ActiveSheet.UsedRange ...READ MORE

answered Jan 31 in Others by narikkadan
• 53,520 points
47 views
0 votes
1 answer

Extract Text after Second Underscore in Excel from right side

The UDF to use. The default separator is ...READ MORE

answered 5 days ago in Others by narikkadan
• 53,520 points
28 views
0 votes
1 answer

How to import data from a HTML table on a website to excel?

Hello  To import any HTML file in excel there ...READ MORE

answered Feb 10, 2022 in Others by gaurav
• 22,960 points
536 views
0 votes
1 answer

How to split text values by a delimiter?

The Split function is what you are looking for: =Split(A1, ...READ MORE

answered Oct 11, 2022 in Others by narikkadan
• 53,520 points
155 views
0 votes
1 answer

Currency conversion:number to words excel

Try looking for javascript solutions to use ...READ MORE

answered Oct 28, 2022 in Others by narikkadan
• 53,520 points
90 views
+1 vote
1 answer

Excel or Google formula to count occurrences of an 8-digit number within a text string

To match an eight-digit number, you may ...READ MORE

answered Dec 24, 2022 in Others by narikkadan
• 53,520 points
74 views
+1 vote
1 answer

Automatically move an entire row of reference cell when one cell is moved or manipulated

You are describing how manually entered data ...READ MORE

answered Jan 15 in Others by narikkadan
• 53,520 points
35 views
0 votes
1 answer

Excel: VLOOKUP from a different Sheet

The worksheet name must be included in ...READ MORE

answered Dec 10, 2022 in Others by narikkadan
• 53,520 points
48 views
0 votes
1 answer

How do you populate a google sheets/excel column with cells from a column in another sheet in the same document?

You have two options on chronology: sheet-by-sheet =QUERY({Sheet1!X:Z; Sheet2!X:Z; ...READ MORE

answered Dec 19, 2022 in Others by narikkadan
• 53,520 points
110 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP