Excel LEFT

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 »

Insert Character or Text to Cells

This post will guide you how to insert character or text in middle of cells in Excel. How do I add text string or character to each cell of a column or range with a formula in Excel. How to add text to the beginning of all selected cells in Excel. How to add character… read more »

Get Workbook Path Only

This post will guide you how to get the current workbook path in Excel. How do I insert workbook path only into a cell with a formula in Excel. Get workbook path with Document Location You can get the workbook path from the document location feature, and copy the location to a cell. Do the… read more »

Extract First or Last N Characters

This post will guide you how to extract the first or last n characters from a text string in one cell in Excel. How do I get the first or last N characters from a string using an Excel formula. How to extract first two or last two characters of a cell with a formula… 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 »

Extract Part of Text String

This post will guide you how to extract part of text string from a cell in Excel. How do I extract a word from a text string in Excel. How to extract a substring from a text string in a Cell in Excel. How to extract a substring from the most left of a text… 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 »

Sorting IP Address

This post will guide you how to sort IP address in your worksheet. How do I sort IP address with an excel formula. How to sort IP address with Text To Columns feature in excel. Sort IP Address with Formula Assuming that you have an IP list of data in the range of cells B1:B5,… 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