Excel Magic Trick #8: Text To Column

Loading...

Sign in or sign up now!
Alert icon
Upgrade to the latest Flash Player for improved playback performance. Upgrade now or more info.
31,114
Loading...
Alert icon
Sign in or sign up now!
Alert icon

Uploaded by on Mar 3, 2008

Excel! Need to separate first and last name into two cells? Need to take a column of text and break it apart into multiple columns? This is called "Text to Column"! See how easy it is to do in Excel! Also, see a cool keyboard shortcut to highlight a whole column of data quickly.

  • likes, 5 dislikes

Link to this comment:

Share to:

Uploader Comments (ExcelIsFun)

  • I Found this Video very Helpful!! Thanks...

  • I am glad that the video helped!

  • nice, there is a little detail that i want you to explain why it happens

    considering the space (or any other) as a separation character, excel will always delete this character. why is that? my situation is that excel deletes the entire word that follows the separation character and that is frustrating

  • I do not know. Try posting to THE best Excel question site:

    mrexcel[dot]com/forum

  • so how do you do the opposite? you have 2 columns but you want to merge them into one.

  • Try the next trick:

    Excel Magic Trick # 9: Join 2 Cells into 1

    Let me know if that accomplishes your goal.

see all

All Comments (16)

Sign In or Sign Up now to post a comment!
  • its really fun.. 

  • great help, thanks!

    

  • Thanks for trick

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