Tag: Excel string functions

How to Use the FILTER Function for Complete and Partial Text Match in Excel

Jun 26, 2025

—

by

Himanshu

in Excel Training

The FILTER function in Excel 365 is a powerful tool that allows you to extract rows from a dataset that meet specific criteria. It dynamically spills the matching results into adjacent cells — and is ideal for creating reports, dashboards, and searchable tables. 🧠 FILTER Function Syntax: excelCopyEdit=FILTER(array, include, [if_empty]) ✅ 1. Complete Match of…
How to Use TEXTBEFORE, TEXTAFTER, and TEXTSPLIT in Excel 365 with Real-World Examples

Jun 26, 2025

—

by

Himanshu

in Excel Training

📘 Overview of the Functions These text functions are new in Excel 365 and Excel 2021, part of the dynamic array functions family. They are useful for splitting or extracting parts of text based on delimiters (like commas, spaces, hyphens, etc.). 🔹 1. TEXTBEFORE ✅ Purpose: Extracts the text before a specified delimiter. 📘 Syntax:…