The RIGHT Function

The RIGHT Function

Ryan Vaughn Ryan Vaughn

Ryan Vaughn

We apply analytics.

Published Feb 27, 2019
+ Follow

Scenario: You want to pull the 5 characters from the right side of a text string. Say you have City, State, Zip in one cell and want the 5 digit zip to be in its own cell. In today's lesson, I show just that. Today's video is 1 minute and 14 seconds.


To view or add a comment, sign in

More articles by Ryan Vaughn

  • Do Airlines Fly More in January or July?
    Jan 25, 2021

    Do Airlines Fly More in January or July?

    In this video, Dr. Winston explains whether airlines fly more in January or July.

  • The XLOOKUP Function
    Sep 19, 2020

    The XLOOKUP Function

    The XLOOKUP Function in Excel will replace the most popular functions such as VLOOKUP, HLOOKUP, and INDEX/MATCH. This…

  • Variance Analysis
    May 24, 2019

    Variance Analysis

    In this video, Dr. Winston shows how to decompose a sales variance into a volume, product mix, and price variance.

  • Product Line Pricing
    May 22, 2019

    Product Line Pricing

    In this video, Dr. Winston shows how changing the price of two products, (specialty and regular coffee) changes the…

  • The Butterfly Effect
    May 21, 2019

    The Butterfly Effect

    In this video, Dr. Winston illustrates the Butterfly effect: If a butterfly flaps its wings in Tahiti it may cause a…

  • The Gravity Model
    May 16, 2019

    The Gravity Model

    In this video, Dr. Winston shows how to implement a complex formula, the Gravity Model which computes market shares for…

  • Depreciation
    May 16, 2019

    Depreciation

    In this video, Dr. Winston shows how to model 3 different methods of depreciation used to depreciate a machine to its…

  • Amortization Schedule
    May 13, 2019

    Amortization Schedule

    In this video, Dr. Winston shows how a loan payment reduces the balance of a loan by the end of the loan term.

  • Modeling Fish in a Pond
    May 13, 2019

    Modeling Fish in a Pond

    In this video, Dr. Winston shows how to create a dynamic model that shows the evolution of the number of fish in a pond.

  • Modeling a Retirement Fund
    May 6, 2019

    Modeling a Retirement Fund

    In this video, Dr. Winston shows how to model the evolution of a retirement fund.

See all articles

Insights from the community

Others also viewed

Explore topics