MID function


Excel » Functions » Text » MID function »

Extract k-th word in cell value

The formula displayed above in cell range D3:D9 extracts a word based its position in a cell value. For example, […]

How to use the MID function

The MID function returns a substring from a string based on the┬ástarting position and the number of characters you want […]

Extract numbers from a value

Chirag asks: I want to separate numbers from following text: Abc123bx45 as a result 123 and 45 should be in […]

Fuzzy vlookup [Array formula]

This formula returns multiple values even if they are arranged differently or have minor misspellings compared to the lookup value.

Exact word in string

I read an interesting blog post Is A Particular Word Contained In A Text String? on Spreadsheetpage. That inspired me […]