Mid Excel Formula




Excel Formulas > Text Functions > MID

« Lower | Mid | Proper »

What is the use of Mid formula?

Gets a portion of text


Syntax of Mid formula:
mid(from this text, start here, this many letters)

Examples of Excel Mid formula:
mid("hello",2,3) = ell
mid("hello",2,99) = ello

Buy Excel Formula E-book | Learn more about Excel Mid Formula

More Text Functions : Concatenate | Find | Left | Len | Lower | Mid | Proper | Rept | Substitute | Trim | Upper | Value

Mathematical Functions | Text Functions | Logical & Reference Functions
Date & Time Functions | Financial Functions | Information Functions

Microsoft Excel Formula Training - Ebook