SUBSTITUTE Function

Excel Formula to Split String by Comma (5 Examples)

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)

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)

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)

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 Remove Tab Space from Excel (5 Easy Methods)

In this article, we will show how to remove unnecessary tab space from your Excel spreadsheet with 5 easy methods. Download Practice Workbook ...

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

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 ...

How to Split Names Using Formula in Excel (4 Easy Methods)

In Microsoft Excel, there must have some cases when you need to split the full name. Excel has several methods to do this. It actually reduces your ...

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

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, ...

Find and Replace Line Breaks in Excel (6 Examples)

In Excel, a line break is frequently used, especially in documenting addresses. Also to view long text inside a singular cell. In many cases, we may ...

How to Remove Line Breaks in Excel (5 Ways)

Line break in Excel means to start a new line or give spacing between text in a cell. Sometimes, you need to remove those line breaks from your ...

How to Replace Line Break with Comma in Excel (3 ways)

When we copy some text from somewhere to our Excel spreadsheet, sometimes some line break is trapped in those data. Removing this line break is quite ...

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

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)

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 Symbol in Excel (8 Ways)

There could be so many unwanted symbols and characters existing in excel cells, maybe from a typing mistake, or a symbol that was needed initially ...

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

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

ExcelDemy
Logo