Skip to content
Excel Nerds

Excel Nerds

Learn Pivot Tables, Vlookup, and Data Analysis

  • Articles
  • Videos
  • Online Excel Training

text

  • Home
  •   »  
  • text
Excel
merge and center text

How to Merge Cells in Excel (with Video)

Merging cells in Excel is easy. 99% of the time this is done for formatting improvements. Below we’ll learn how to

06 Oct
Excel
concat vs. concatenate

How to Use CONCATENATE in Microsoft Excel

There are actually two functions you can use to concatenate data; CONCATENATE and CONCAT. While the CONCATENATE and CONCAT

01 Sep
Videos
left, right, and mid functions

Learn the LEFT, RIGHT, and MID Functions in Excel

Here’s a quick intro the functions LEFT, RIGHT, and MID. These are very important if parsing data from larger strings

Videos
substitute function excel

How to use the Substitute Function (Video)

If cleaning up messy data is part of your work flow, the substitute function is sure to come in helpful. Learn how to use it here:

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

06 Oct
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

27 Sep
Functions 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

Functions 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

Functions 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

Posts navigation

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