Added: 4 years ago
From: ExcelIsFun
Views: 31,768
Sort by time | Sort by thread (beta)

Link to this comment:

Share to:

All Comments (21)

Sign In or Sign Up now to post a comment!
  • great help..

  • how do you take a list of data (which is 10 pages long) and that is one column and place them into two columns.?

  • Awesome video!! Easiest to understand!

  • @yiwsg , I am glad that you liked it!

  • thanks you awesome !!!

  • @d0n0n0n , I am glad that it helped!

  • oh my god, I've spent hours today trying to figure out what you ust showed me in 2 minutes. Thank you!!!!!

  • You are welcome!!!!

  • Great postings!

    Now, let's say I have a cell with name and last name,

    Can I split it into two cells, one for the name and the other for the last name?

  • Here are a few videos that may help:

    Excel Magic Trick 292: Reverse Last & First Name Tricks

    Excel Magic Trick #192: Extract Middle Name Text To Column

    Highline Excel Class 13: Text functions & AMPERSAND

    Excel Magic Trick #190: Rearrange First Last Name w Formula

    Excel Magic Trick 511: Extract First, Middle, Last Names From Bad Data With Extra Characters

    Excel Magic Trick 562: Extract Names - Some Names In List Have Middle Name Some Do Not

  • @ExcelIsFun Awesome. Thanks a million for yout help

  • Wow these videos are so amazingly helpful and great to learn from. I came across thes vids by chance looking for help with a particular excel function, now i am wathching them all. I paid over $300 to do an excel course which is not as well instructed as these vids. Great work SIr. I will be working at Microsoft by the end of all these vids!!!!. How can i bring up a list of all shortcuts?

  • If you are trying to teach yourself Excel through these videos then you wnat to watch the Excel Basic Series and then the Highline Excel Class series, in the order. Search for this video title and watch this video to see how to find the playlists:

    excelisfun Search & Find Excel Videos, Playlists, Download Excel Workbooks.

    I do not have a list of shortcuts, sorry.

  • That is amazing. Thanks for the help!

  • You are welcome!

  • You are amazing! I watched your videos of "Excel Basics" and now I`m watching Excel Tricks.

    You are so inspiring to me ... and "because" of you :) I`m continuously improve my skills in Excel.

    Thank you a lot

  • You are welcome! I am glad to help!

    Try the "highline Excel Class" series, it is the best for learning.

  • ........

  • GREAT JOB on all your videos!!!!

  • I am glad to help!

Loading...
Alert icon
0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more