ExcelHow

Tag: Excel SUBSTITUTE

How to replace all characters before the first specific character

Excel Examples

July 8, 2024
How to Convert DD-MM-YYYY text string or date to a standard date format in Excel

Excel Examples

June 28, 2024
How to convert Column Letter to Number in Excel

Excel Examples, Excel VBA

April 14, 2024
How to Sort List of Cells by Word Count

Excel Examples

March 31, 2024
Split Text and Numbers in Excel

Excel Examples, Excel Text Functions

March 29, 2024
How to Sort Name by Last Name in Excel

Excel Basics, Excel Examples

March 27, 2024
How to remove all spaces between numbers or words

Excel Examples

March 24, 2024
How to Split Multiple Lines from a Cell into Rows

Excel Examples

March 24, 2024
How to Remove Leading and Trailing Spaces

Excel Basics, Excel Examples

March 20, 2024
How to Count the Number of Letters or Numbers separately in a Cell in Excel

Excel Examples

March 16, 2024
How to Remove Line Breaks (Carriage Returns) in Excel

Excel Examples, Excel VBA

March 10, 2024
How to Remove Specific Character from Text Cell in Excel

Excel Examples

March 6, 2024
How to replace all characters after the first specific character

Excel Examples

February 26, 2024
How to get last word from text string

Excel Examples

January 23, 2024
How to Extract Last Two Words From Multiple Cells

Excel Examples

January 21, 2024
How to Find and Replace Multiple Values

Excel Examples, Excel VBA

January 9, 2024
How to get the position of Last Occurrence of a character or string in a cell

Excel Examples

January 4, 2024
How to Replace Last Comma in String with “and” word

Excel Examples

December 10, 2023
How to extract word that containing a specific character

Excel Examples

November 26, 2023
How to Count Comma Separated Value in One Cell in Excel

Excel Examples

September 6, 2023