ExcelHow

Category: Excel Examples

How to get the position of Last Occurrence of a value in a column

Excel Examples

November 30, 2017
Three Ways to get the First Row Number in a Range

Excel Examples

November 29, 2017
How to Find the Relative Position in a Range or Table

Excel Examples

November 29, 2017
How to Split Text String to an Array

Excel Examples

November 28, 2017
How to Remove Numeric Characters from a Cell

Excel Examples

November 27, 2017
Get Last Name From Full Name

Excel Examples

November 26, 2017
The different between FIND and SEARCH functions

Excel Examples

November 26, 2017
Get First Name From Full Name

Excel Examples

November 25, 2017
Get Path and Workbook name only

Excel Examples

November 25, 2017
Get full File Name (workbook and worksheet) and Path

Excel Examples, Excel Text Functions

November 24, 2017
Get the Current Worksheet Name only

Excel Examples, Excel Text Functions

November 24, 2017
Data Validation for Specified Text only

Excel Examples, Excel Text Functions

November 23, 2017
Get the Current Workbook Name

Excel Examples, Excel Text Functions

November 23, 2017
Get the Position of Second or Third of the Specified Character within a String

Excel Examples, Excel Text Functions

November 22, 2017
Split Text String by Specified Character in Excel

Excel Examples

November 20, 2017
The difference between Replace function and Substitute function in Excel

Excel Examples, Excel Text Functions

November 19, 2017
Using Find and Replace Tool to replace text in Excel

Excel Examples

November 19, 2017
Excel Replace Function Remove Text String

Excel Examples, Excel Text Functions

November 18, 2017
Combining the REPLACE Function with FIND Function to Remove Text in Excel

Excel Examples, Excel Text Functions

November 18, 2017
Combining the Replace function with Text function in Excel

Excel Examples, Excel Text Functions

November 17, 2017