ExcelHow

Tag: Excel SUBSTITUTE

How to Convert Date Format from Dot MM.DD.YYYY to Slash MM/DD/YYYY in Excel

Excel Examples

July 30, 2023
How to Remove the First/Last Word from Text string in Cell

Excel Examples, Excel VBA

April 16, 2023
How to Extract Email Address from Text

Excel Examples, Excel VBA

April 16, 2023
How to extract text after the second or nth specific character (space or comma)

Excel Examples, Excel VBA

April 8, 2023
How to Get the Position of the nth Occurrence of a Character in a Cell

Excel Examples

April 6, 2023
How to Remove Quotes for Text or Strings in Excel

Excel Examples

February 26, 2023
How to Reverse Concatenate Formula in Excel

Excel Examples

February 21, 2023
How to count the number of line breaks in a cell

Excel Examples

February 19, 2023
How to Remove All Asterisk Characters from Cells in Excel

Excel Examples

February 19, 2023
Extract Multiple Lines From A Cell

Excel Examples

January 29, 2022
Removing Dash Characters in Excel

Excel Examples

September 7, 2018
Insert The File Path and Filename into Cell

Excel Examples

August 31, 2018
Sort Cells by Specific word or words

Excel Examples

July 13, 2018
Remove Spaces from a String

Excel Examples

May 31, 2018
How to Add a Character or Letter before Each Word in a Cell

Excel Examples, Excel Functions

February 18, 2018
Sort Names by Middle Name in Excel

Excel Basics, Excel Examples

February 7, 2018
Split full name to first and last name

Excel Examples

January 24, 2018
How to remove unwanted characters from text string

Excel Examples

January 16, 2018
How to extract nth word from text string

Excel Examples

January 14, 2018
How to count the number of words in a range of cells in Excel

Excel Examples

January 10, 2018