top of page

One Excel shortcut to rule them all

Updated: Sep 13, 2022

What if I told you that by watching this 1 minute video will save you hours of time?


There is an Excel shortcut that rules them all. This one time-saving shortcut is so good, it can be used in at least 7 different scenarios:

  1. Split Columns

  2. Join Columns

  3. Add Text or Values to existing data

  4. Get the initials from a list of names

  5. Convert Text

  6. Extract the data from the middle of a code

  7. Extract numbers like the Year from a Date

This one shortcut does all of the above, which is why I call it the Lord of the Shortcuts, the One Shortcut that Rules them all (I really need to get out more!).


Click here to watch this short video - I tried something a little different with this one.


Get the exercise file to follow along with the video and practice.



22 views0 comments
Sign up circies (3).png

Tony Laskowski

Applications Trainer & Digital Creator

Ready Steady Excel was set up by Tony to help a wider audience to achieve more with Microsoft 365.

Join the Mailing List to keep on track!

Untitled%252520design%252520(3)_edited_e

Discover More!

100% Free Sign Up - Unsubscribe Anytime!

bottom of page