Mid Formula In Excel

 

The MID formula in Excel stands for "middle" and is used to extract a specific number of characters from a text string, starting from a specified position.

The syntax of the MID formula is as follows:

scss
=MID(text, start_num, num_chars)

• "text" refers to the text string from which you want to extract the characters.
• "start_num" refers to the position within the text string from which you want to start extracting characters. The first character in the text string is at position 1.
• "num_chars" refers to the number of characters you want to extract from the text string.

For example, suppose you have a text string in cell A1 that reads "Hello World". If you want to extract the word "World" from this string, you could use the MID formula as follows:

scss
=MID(A1, 7, 5)

This formula will start extracting characters from position 7 in the text string ("W") and extract a total of 5 characters, which includes the word "World". The result will be "World"