excel RIGHT

How to remove first and last characters from text string

This post will guide you how to remove the first character from a text string using excel formula. How to remove the last character from string in Excel. How to remove the first x number of characters from a text string. How to delete the last x number of characters from string. Remove First Character… read more »

How to get last word from text string

This post explains that how to extract the last word from a text string in excel. How do I get the last word in a text string using excel formula. Extract last word If you want to get the last word from a text string, you can create an excel formula based on the RIGHT… read more »

How to remove text before the first match of a specific character

This post explains that how to remove text before the first occurrence of the comma character in a text string in excel. How to remove all characters before the first match of the comma or others specific characters in excel. Remove text before the first match of a specific character If you want to remove… read more »

How to Convet Text Date dd/mm/yy to mm/dd/yyyy as Date Format

This post explains that how to convert text date in the format dd/mm/yy to the standard date format mm/dd/yyyy in excel. How to change dates in text format dd/mm/yy to mm/dd/yyyy as date format in excel 2013. Convet Text dd/mm/yy to mm/dd/yyyy as Date Format If you want to convert dates in the text format… read more »

Get Last Name From Full Name

This post will guide you how to extract the last name within a Full name in excel. You need to use a combination of the RIGHT function, the LEN function, the FIND function and the SUBSTITUTE function to create a complex formula in excel. Get Last Name From Full Name You can use the below… read more »

Split Text and Numbers in Excel

This post explains how to split text and numbers in excel, or how to extract the text characters from another strings with text and numbers combined. Split Text and Numbers If you want to split text and numbers, you can run the following excel formula that use the MIN function, FIND function and the LEN… read more »

Split Text String by Line Break in Excel

In the previous post, we talked that how to split text string by a specified character in excel. And this post will guide you how to split text string by Line Break character. The difference is that you can type the line break character directly in the FIND function and you have to use the… read more »

Split Text String by Specified Character in Excel

This post explains how to split text string by a specified character (such as: comma, space, dash, slash, etc.) using FIND function within other functions in excel. And you will learn that how to extract part of characters to the left of a specified character in one cell. Split Text String by Specified Character When… read more »

Excel Right Function

This post will guide you how to use Excel RIGHT function with syntax and examples in Microsoft excel. Description The Excel RIGHT function returns a substring (a specified number of the characters) from a text string, starting from the rightmost character. The RIGHT function is a build-in function in Microsoft Excel and it is categorized as a Text Function. The RIGHT function is… read more »

Sidebar