ExcelHow

Tag: Excel Function

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
Split Text String by Line Break in Excel

Excel Examples, Excel Text Functions

March 19, 2024
How to Combine Text from Two or More Cells into One Cell

Excel Examples

March 16, 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 Create an Array of Numbers

Excel Examples

January 19, 2024
How to remove first and last characters from text string

Excel Examples

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

Excel Examples

January 4, 2024
How to Extract multiple match Values into different Columns or Rows

Excel Examples

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

Excel Examples

November 26, 2023
Excel nested if statements with ranges

Excel Examples, Excel Logical Functions

November 26, 2023
How to Use Excel SUMXMY2 Function

Excel Math/Trigonometry Functions

November 19, 2023
How to extract text before first comma or space

Excel Examples, Excel VBA

August 7, 2023
How to Extract Text between Brackets

Excel Examples, Excel VBA

July 30, 2023
How to Count Spaces before the Text String

Excel Examples, Excel VBA

April 18, 2023
How to Transpose Values Based on the Multiple Lookup Criteria

Excel Examples

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

Excel Examples, Excel VBA

April 8, 2023
How to Count Numbers with Leading Zeros

Excel Functions, Excel VBA

April 8, 2023
How to remove non numeric characters from a cell

Excel Examples

April 7, 2023