From the course: Excel Formulas and Functions Quick Tips
Join today to access over 24,700 courses taught by industry experts.
Extract substrings with MID - Microsoft Excel Tutorial
From the course: Excel Formulas and Functions Quick Tips
Extract substrings with MID
- Is The mid function will give you a set number of characters from a string starting where you specify based on how many characters you specify. In this cell, I'm interested in the three middle characters. I need to pull that number out. I'll start typing equals mid, open my parentheses, and put in my cell reference for text, in this case, the contents of cell A2. After the comma, I need to specify the position of the first character that I want to extract. In this case, I need the third character over. I'll put in a comma and now I need to specify how many characters I want to extract. Again, in this case, three. I'll close the parentheses and here's my middle extracted number. I can fill down to get the information that I need.
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.
Contents
-
-
-
-
-
-
(Locked)
Format numbers and dates with TEXT2m 4s
-
(Locked)
Extract characters with LEFT AND RIGHT1m 20s
-
(Locked)
Extract substrings with MID56s
-
(Locked)
Count characters with LEN1m 7s
-
(Locked)
Identify where a character occurs with FIND1m 59s
-
(Locked)
Join strings with delimiters with TEXTJOIN1m 48s
-
(Locked)
Change text with SUBSTITUTE and REPLACE1m 55s
-
(Locked)
-
-
-