Excel Mid Function

The MID function in Excel is used to extract a substring from within a text string. Here's the basic syntax:

=MID(text, start_num, num_chars)

text : This is the text string from which you want to extract characters.
num_chars:This is the position of the first character you want to extract. It's 1-based, meaning the first character is 1, the second is 2, and so on.
num_chars: This is the number of characters you want to extract.

For example, if you have the text string "Hello, World!" in cell B3 and you want to extract "World!", you would use:

Mid Formula used in B3

Next