Text Function | How to use the Excel MID Function?



In the previous post, we saw ‘Text Function | How to use the Excel ‘T’ Function?’, now we will learn about ‘How to use the Excel MID function?’.

Where to Find the Text Function?

To find the text function in excel open excel and click on the “Blank” to open a blank excel worksheet now click on the ‘Formula Tab’ and under ‘Function Library’ click on the ‘Text’ option as shown below:

excel lower function

You can also see the text function via shortcut key – press ‘ALT + M + T’ after that select the text function that you want to use.


What is Excel MID Function?

Advertisements

The Excel MID function returns a specific number of characters from a text string, starting at the position you specify, based on the number of characters you specify.


Syntax

MID(text, start_num, num_chars)


Arguments

The MID function syntax has the following arguments:

Text    Required. The text string containing the characters you want to extract.

Start_num    Required. The position of the first character you want to extract in the text. The first character in the text has start_num 1, and so on.

Num_chars    Required for MID. Specifies the number of characters you want MID to return from the text.


Understand With Example

excel mid

If you want to make the lower case, The Excel LOWER function Converts all uppercase letters in a text string to lowercase. It ignores space, numbers, and punctuation. Visit this link – Excel LOWER Function.

The Excel PROPER function Capitalizes the first letter in a text string and any other letters in the text that follow any character other than a letter. It Converts all other letters to lowercase letters. Visit this link – Excel PROPER Function


For Latest Updates & Learning Join Our YouTube Channel: Join Now

author

EduTaxTuber Team

We are here to help for every updates related to everything...👍📙👍📗

Similar Posts

Leave a Reply

England vs Senegal: FIFA World Cup 2022 No Curfew in Mumbai: Section 144 Imposed to ensure Peace Elon Musk suspends Kanye West Twitter Account for inciting violence Pak Vs England: England vs Pakistan FIFA World Cup 2022: CBDT Notifies Income Tax Exemption
Ads Blocker Image Powered by Code Help Pro

Ads Blocker Detected!!!

We have detected that you are using extensions to block ads. Please support us by disabling these ads blocker.

Powered By
Best Wordpress Adblock Detecting Plugin | CHP Adblock