Skip to content
Excel Nerds

Excel Nerds

Learn Pivot Tables, Vlookup, and Data Analysis

  • Excel Tutorials
  • Excel Video Lessons
  • Contact

right formula

  • Home
  •   »  
  • right formula
Excel
top things to know in Excel

Top 5 Things to Know in Excel

I remember listing “Microsoft Excel” as a skill on my resume just out of college. The only functions I knew how

Excel
text - len, right, left, mid

Manipulating Text in Excel – LEN, RIGHT, LEFT, & MID

There are many times in Excel when you only need to extrapolate or evaluate PART of a cell. For this, the following functions

Excel Functions Excel Text Functions
RIGHT – Excel Function

RIGHT – Excel Function

What it does: The RIGHT() Function removes a string from the right side of a given piece of text according to parameters you

Excel Functions Excel Text Functions
LEFT – Excel Function

LEFT – Excel Function

What it does: The LEFT() Function removes a string from the left side of a given piece of text according to parameters you

Excel Functions Excel Text Functions
MID – Excel Function

MID – Excel Function

What it does: The MID() Function returns a specific part of a larger text string, subject to the arguments you provide. Plain

Excel Functions Excel Text Functions
Char Function Microsoft Excel

CHAR – Excel Function

What it does: The CHAR() returns the character specified by a number. Plain English: When you see CHAR(), think

Excel Functions Excel Text Functions
UPPER – Excel Function

UPPER – Excel Function

What it does: The UPPER() Function converts text to lowercase. Plain English: Simple. This function converts text to be all

Excel Functions Excel Text Functions
LOWER – Excel Function

LOWER – Excel Function

What it does: The LOWER() Function converts text to lowercase. Plain English: Simple. This function converts text to be all

Excel Functions Excel Text Functions
LEN – Excel Function

LEN – Excel Function

What it does: The LEN() function returns the length (number of characters) of a given text or string. Plain English: This

Posts navigation

1 2 »
  • Articles
  • Excel Training Videos
  • Online Training
  • About
  • Contact
  • Excel Functions
    • Excel Text Functions
    • Excel Math Functions
    • Excel Logical Functions
    • Excel Lookup and Reference Functions
Copyright ©2023 Excel Nerds - Learn Pivot Tables, Vlookup, and Data Analysis
Developed by WOWLayers.com