Excel LEN

How to Split Cells by the First Space in Texts in Excel

Sometimes we may use space to separate texts to different groups in one cell, if we want to split this cell to multiple columns refer to space, we can implement this via ‘Text to Columns’ feature. But is there any way to split one cell to only two cells by the first space in the… read more »

How to Convert Uppercase to Lowercase Except the First Letter in Excel

In excel, words can be entered in uppercase, lowercase or mixed. If we want to convert all uppercase to lowercase (except the first letter in some situations), we can use formula with some letter convert related functions to convert them to proper case. This article will introduce you some methods to convert letters from uppercase… read more »

How to Remove Middle Name from Full Name in Excel

When we get a list of full names, we can remove the middle name for short in some cases. As the middle names are different among the full name list so we cannot replace them by space directly in excel. This article will provide you two methods to remove the middle name. User can use… read more »

How to Remove Last or Trailing Commas in Excel

This post will guide you how to remove trailing commas from cell in Excel. How do I remove comma character at the end of a cell with a formula in Excel 2013/2016. Remove Trailing Commas if you want to remove trailing commas from you Excel cells, and you can create a formula to check for… read more »

How to Count Comma Separated Value in One Cell in Excel

This post will guide you how to count values in a single cell separated by commas with a formula in Excel. How do I count comma separated values in one cell in Excel 2013/2016. Is it possible to have a formula that can count the amount of values separated by commas in a single cells… read more »

How to Sort Column by Length of Cell Characters in Excel

This post will guide you how to sort column values by length of the characters in one column in Excel. How do I sort a list of column by character length in Excel 2013/2016. Sort Column by Length of Cell Characters using Sort Feature Assuming that you have a list of data in column A… read more »

How to Extract Text between Two Text Strings in Excel

This post will guide you how to extract text between two given text strings in Excel. How do I get text string between two words with a formula in Excel. Extract Text between Two Text Strings Assuming that you have a list of data in range B1:B5, in which contain text string values. And you… read more »

How to Remove the First/Last Word from Text string in Cell

This post will guide you how to remove the first and the last word from a text string in cells in Excel. How do I use a formula to remove first and last word of a text string in Excel. Remove the First Word from Text String Remove the Last Word from Text String Remove… read more »

How to Remove Prefix and Suffix in Given Cells in Excel

This post will guide you how to remove suffix form a range of cells in Excel. How do I remove prefix from text string in cells with a formula in Excel. Remove Prefix of Cells Remove Suffix of Cells Assuming that you have a list of data in range B1:B5, you want to remove the… read more »

Extract Email Address from Text

This post will guide you how to extract email address from a text string in Excel. How do I use a formula to extract email address in Excel. How to extract email address from text string with VBA Macro in Excel. Assuming that you have a list of data in range B1:B5 which contain text… read more »

Reverse Text String in Excel

This post will guide you how to reverse text string in Excel. How do I reverse text string in one cell with an Excel User Defined Function. How to reverse a text string in one cell with a formula in Excel. Reverse Text String with User Defined Function You can easily write down a User… read more »

Insert The File Path and Filename into Cell

This post will guide you how to insert the file path and filename into a cell in Excel. Or how to add a file path only in a specified cell with a formula in Excel. Or how to add the current workbook name into a cell in Excel. How do I insert the current worksheet… read more »

Removing Salutation from Name

This post will guide you how to remove salutations from names in the range of cells in excel. How do I remove the salutation from the names cells with formula in Excel. For example, if you have name salutations and you want to remove those salutations from name strings in excel, how to achieve it…. read more »

Replace Last Comma in String with “and” word

This post will guide you how to replace last comma character in a string in cells with “and” word in excel. How do I replace the last comma character from a string with another word “and” using an excel formula. How to replace last instance of comma with ‘and’ in a string in excel. Replace… read more »

Sort List of Cells by Word Count

This post will guide you how to sort list of cells in excel by word count from the smallest to the biggest. How do I sort on word number of cells with a formula in a column in excel. Sort List of Cells by Word Count If you want to sort the list by word… read more »

Sort Cells by Specific word or words

This post will guide you how to sort cells or text values in a column based on a specific word even if the word is in the text string in the cell. How do I sort cells in a column by the number of a specific word or words in excel. Sort Cells by Specific… read more »

Highlight Cells That End with Specfic Characters

This post will guide you how to highlight values that end with a specific character or text string in excel. How do I highlight cells that end with a string using the conditional formatting feature in excel. Assuming that you want to highlight cells that end with the text string “excel” in the range A1:B4,… read more »

Split Text and Numbers

This post will guide you how to separate text and numbers from one cell in excel. How do I extract numbers from text string with formulas in Excel. Split Text and Numbers with Formula If you want to split text and numbers from one cell into two different cells, you can use a formula based… read more »

Sidebar