What are RIGHT, RIGHTB functions in Excel?
RIGHT, RIGHTB functions are TEXT functions in Microsoft … Read More
How to split text string at specific character in Excel
To split a text string at a certain character, you can use a combination of … Read More
How to get sheet name only in Excel
If you want to get the sheet name only (i.e. the sheet name without the … Read More
How to get top level domain (TLD) in Excel
To extract the top level domain (called “TLD”) from a list of domain names or … Read More
Extract last name from full name — Manipulating NAMES in Excel
If you need extract the last name from a full name, you can do so … Read More
Get first name from name with comma — Manipulating NAMES in Excel
To extract the first name from a full name in “Last, First” format, you can … Read More
Split numbers from units of measure in Excel
To split a number from a unit value, you need to determine the position of … Read More
Split dimensions into three parts in Excel
To split dimensions that like 100x50x25 into three separate parts, you can use some rather … Read More
Remove first character in a cell in Excel
To remove the first character in a cell, you can use the REPLACE function.
Formula
How to get last line in cell in Excel
To get the last word from a text string, you can use a formula based … Read More
How to extract substring in Excel
To extract a substring with an Excel formula, you can use the MID function.
Note: … Read More
Convert text to numbers using VALUE function in Excel
To convert simple text values to numbers, you can use the the VALUE function, or … Read More
Convert text date dd/mm/yy to mm/dd/yy in Excel
This tutorial shows how to Convert text date dd/mm/yy to mm/dd/yy in Excel using example … Read More
Convert text to date in Excel
This tutorial show how to Convert text to date in Excel using the example below.… Read More
Get date from day number in Excel
This tutorial show how to get date from day number in Excel using the example … Read More
Highlight cells that end with in Excel
This tutorial shows how to Highlight cells that end with in Excel using the example … Read More
How to Separate Text Strings in Excel
This example teaches you how to separate strings in Excel. Asides from using ‘Convert Text … Read More
Count Number of Words in Excel
This chapter shows how to count the number of words in a cell.
1a. The … Read More
Manipulating text strings using Left, Mid, Right, Len, Substitute in Excel
Excel has many functions to offer when it comes to manipulating text strings.
Formula tab … Read More