Excel-Formula Return Partial Text - Search Videos

FILTER with partial match

FILTER with partial match

To use select records from a set of data based on a partial match, you can use the FILTER function with the SEARCH function. In the example shown, the formula in G7 is: =FILTER(Table1,ISNUMBER(SEARCH(H4,Table1[Last]))*(H4 ""),"No results") where Table1 is an Excel Table that contains 100 rows of data in B5:E104.

Excel Text Functions

TEXT Function

Excel Text Function Tutorial | Excel Text Functions Tutorial Learn All Text Functions with Examples

Excel Text Function Tutorial | Excel Text Functions Tutorial Learn All Text Functions with Examples

YouTubeDesign MK Cad Tutorial

85 viewsApr 30, 2025

18 Text Functions in Excel You Need to Know

18 Text Functions in Excel You Need to Know

YouTubeHow to Excel

156.6K viewsMay 16, 2020

Top videos

Partial match with VLOOKUP

Partial match with VLOOKUP

Partial match with numbers and wildcard

Partial match with numbers and wildcard

VLOOKUP Contains (Partial Match) - Excel & Google Sheets

VLOOKUP Contains (Partial Match) - Excel & Google Sheets

automateexcel.com

Excel Concatenate Text

Combine text from two or more cells into one cell in Microsoft Excel

Combine text from two or more cells into one cell in Microsoft Excel

How to Use "CONCATENATE" "CONCAT" And "&" Functions in Excel

How to Use "CONCATENATE" "CONCAT" And "&" Functions in Excel

YouTubeExcel 10 tutorial

5.4K viewsJul 5, 2020

How to Use the CONCATENATE Formula in Excel | Quick Tutorial

How to Use the CONCATENATE Formula in Excel | Quick Tutorial

YouTubeLearn More Skills

5K viewsOct 19, 2024

Partial match with VLOOKUP

Partial match with VLOOKUP

Partial match with numbers and wildcard

Partial match with numbers and wildcard

VLOOKUP Contains (Partial Match) - Excel & Google Sheets

VLOOKUP Contains (Partial Match) - Excel & Google Sheets

automateexcel.com

INDEX and MATCH all partial matches

INDEX and MATCH all partial matches

How to Use TEXTBEFORE and TEXTAFTER in Excel

How to Use TEXTBEFORE and TEXTAFTER in Excel

Extract text between parentheses

Extract text between parentheses

Cell contains specific text

Cell contains specific text

How to Extract Text Before or After Character in Excel and Google Sh…

automateexcel.com

How to Use REPLACE Function in Excel

199.6K viewsJul 6, 2020

YouTubeExcel 10 tutorial

How to use the MATCH function in Excel

331K viewsAug 3, 2021

YouTubeTechOnTheNet

If Text Contains Word - Excel & Google Sheets

140.2K viewsNov 13, 2019

YouTubeLearn Google Sheets & Excel Spreadsheets

How to Use the IFS Function in Excel

417.9K viewsJul 9, 2020

YouTubeLeila Gharani

How to use the IF function in Excel

2.3M viewsOct 4, 2018

YouTubeTechOnTheNet

Microsoft Excel - Adding a Return in a Cell

11K viewsSep 18, 2015

YouTubeSandor Rethy

How to Extract Part of Text String from an Excel Cell

419.5K viewsMar 15, 2021

YouTubeSimon Sez IT

Excel: Check IF Cell CONTAINS TEXT From LIST

202.8K viewsJun 3, 2020

YouTubeChester Tugwell

Wildcard Vlookup to Return All Partial Matches in Excel

15K viewsJun 2, 2020

YouTubeTeachExcel

How to extract data from inside a cell in Excel using LEFT, RIGHT, …

41.8K viewsJan 17, 2017

YouTubeExcel Tutorials by Y. Acosta

Delete the First/Last Word or Part from a Cell in Excel

76.4K viewsMar 10, 2020

YouTubeTeachExcel

Excel Cell Reference: Absolute, Relative or Mixed?

549.7K viewsJun 28, 2018

YouTubeLeila Gharani

How to Test IF Cell CONTAINS TEXT - Excel Tutorial

26.8K viewsMay 29, 2020

YouTubeChester Tugwell

How to Trim or Remove Text in Excel

918.9K viewsJul 8, 2012

YouTubeSavoir-Faire Tips & Tricks

Excel Find And Replace Trick. (Match Entire Cell Contents)

97.4K viewsNov 30, 2020

YouTubeHow To Excel At Excel.Com

Extract Text from cells in Excel - How to get any word from a cell i…

930.7K viewsJan 6, 2009

YouTubeTeachExcel

How to Return a Value If a Cell Contains a Specific Text in Excel

89.2K viewsNov 14, 2018

YouTubeExcelHow Tech

Conditional Formatting For A List Of Partial Matches In Excel!

39.2K viewsFeb 11, 2021

YouTubeExcel Campus - Jon

If Cell Contains Text - If Cell Contains Certain Text Then Retur…

32.1K viewsFeb 14, 2019

YouTube28 November 2016

IF Function with Multiple Partial Match Text String Criteria

44.1K viewsJan 18, 2018

YouTubeChester Tugwell

Formula To Retrieve First Value In Each Column | MS Excel Tutorial

11.7K viewsJun 19, 2019

YouTubeJie Jenn

See more videos