Excel LEFT

Highlight Rows

This post will teach you how to highlight rows in a table with conditional formatting in Excel. You will learn that how to change the color of the entire rows if the value of cells in a specified column meets your conditions, such as, if the value of cells is equal to or greater than… read more »

How to Count Spaces before the Text String

This post will guide you how to count the number of spaces before the text string in a cell in Excel. How to count the leading spaces before the text string in one cell with formula in excel. How do I create an excel formula that counts the number of spaces before the text string…. read more »

How to Check If the First Letter is capitalized

This post explains that how to check if the first letter in a cell is capitalized or not in excel. How to write an excel Macro to check if the first letter in a specified cell is capitalized or not. How to test if the first letter in a table cell is capitalized with VBA… read more »

Split full name to first and last name

This post will guide you how to split the full name to the first name and last name in the different cells in excel. How to create an excel formula to split the full name to first name and last name. How to get the middle name from the full name string using a formula…. read more »

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 first word from text string

This post will guide you how to extract the first word from a text string in excel. How to get the first word in a text using excel formula. Get First word If you want to extract the first word from a text string in a cell, you can use a combination of the IF… read more »

How to replace all characters before the first specific character

This post will guide you how to replace all characters before the first match of a specific character with a new text string in excel. How to replace substring before the first occurrence of the comma character with another substring in a text string using excel formula. Replace all characters before a specific character If… read more »

How to remove text after a specific character

We talked that how to remove all characters before the first match of the comma character in the previous post. And this post will teach you how to remove text after the first occurrence of the comma character in a text string in excel. Remove text after a specific character If you want to remove… read more »

How to extract text before first comma or space

This post explains that how to extract a substring before the first specific character, such as: comma or space character. How to get text before the first comma in a text string using a formula in excel. Extract text before first comma or space If you want to extract text before the first comma or… read more »

Sidebar