FIND Function Archives

How to Split Names in Excel into Two Columns (4 Quick Ways)

May 18, 2022 Excel Formulas

If your Excel worksheet contains full names in a column and you want to split the names into two columns, then you are in a right place. In this ...

Excel Formula to Split String by Comma (5 Examples)

May 14, 2022 Excel Formulas

You may have a table in your Excel worksheet where several kinds of data are kept in a cell and separated by commas. If you want to split them into ...

How to Split Text in Excel by Character (5 Quick Methods)

May 11, 2022 Excel Formulas

In this article, you will learn 5 methods to split a text in Excel by a character step-by-step. Download Practice Workbook You can download ...

Separate Decimal Numbers from Text in Excel (6 Quick Ways)

May 10, 2022 Excel Formulas

This article will show how to separate decimal numbers from text in Excel. The following image highlights the purpose of this article. ...

How to Split Column in Excel by Comma (8 Quick Methods)

May 10, 2022 Excel Formulas

In this article, you will learn 8 different methods to split a column in Excel by a comma with ease. Download Practice Workbook You can ...

How to Split Text in Excel Using Formula (5 Easy Ways)

Apr 27, 2022 Excel Formulas

Excel has many features to split text. But if you want to do it only using formulas then are several ways to do it. And using the formula is one of ...

Excel Formula to Separate First Middle and Last Name (With Example)

May 19, 2022 Excel Formulas

This article will show how to separate the first name, middle name, and last name with the help of an Excel formula. To get a quick view on this, ...

How to Extract Text after Second Comma in Excel (6 Methods)

Apr 20, 2022 Excel Formulas

If you are looking for some special tricks to extract text after the second comma in Excel, you've come to the right place. In Microsoft Excel, there ...

How to Count Space Before Text in Excel (4 Ways)

Apr 13, 2022 Excel Basics

This article mainly focuses on counting spaces before a text in an Excel cell. Extra spaces can be caused by directly copying and pasting from a ...

How to Remove Specific Text from a Column in Excel (8 Ways)

Apr 21, 2022 Excel Formulas

This article illustrates 8 different methods for how remove specific text from a column in excel. Deleting specific redundant text manually from a ...

How to Extract Text Between Two Characters in Excel (4 Methods)

Apr 6, 2022 Excel Formulas

If you are looking for some special tricks to extract text between two characters in Excel, you've come to the right place. In Microsoft Excel, there ...

How to Extract Specific Data from a Cell in Excel (3 Examples)

Apr 6, 2022 Excel Basics

Excel provides different ways to extract different data, mostly relying on different functions. Some may be extracted directly from specific ...

How to Find Excel Sheet Name Using Formula (3 Examples)

Mar 31, 2022 Excel Formulas

In a Microsoft Excel file usually, we get the sheet name from the bottom of each sheet. But there are other options to find sheet names. We will ...

How to Count Characters in Cell up to Space in Excel

Mar 17, 2022 Excel Formulas

This article illustrates how to count characters in a cell up to space in excel. Other examples of counting characters in cells in excel are also ...

How to Remove Spaces in Excel with Formula (5 Quick Ways)

May 24, 2022 Excel Formulas 2

In this article, we will learn to remove spaces in excel with the formula. Spaces create many problems when we try to execute any formula in the ...