ExcelHow

Tag: Excel SUBSTITUTE

How to Count Comma Separated Value in One Cell in Excel

Excel Examples

September 6, 2023
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
Find and Replace Multiple Values

Excel Examples, Excel VBA

February 18, 2022
Extract Last Two Words From Multiple Cells

Excel Examples

January 31, 2022
Extract Multiple Lines From A Cell

Excel Examples

January 29, 2022
How to Remove Specific Character from Text Cell in Excel

Excel Examples

July 26, 2019
How to Count the Number of Letters or Numbers separately in a Cell in Excel

Excel Examples

February 16, 2019
How to Remove Line Breaks (Carriage Returns) in Excel

Excel Examples, Excel VBA

January 4, 2019
How to Convert DD-MM-YYYY text string or date to a standard date format in Excel

Excel Examples

December 12, 2018
How to convert Column Letter to Number in Excel

Excel Examples, Excel VBA

November 15, 2018
Removing Dash Characters in Excel

Excel Examples

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

Excel Examples

August 31, 2018