Excel Forum
Similar Content
Split Cells with Multiple Lines - Text-to-Columns using Carriage Return
Tutorial: How to split a cell by each line of data within it; this will put each line into its own ...
Convert Numbers Stored as Text to Numbers in Excel
Tutorial: I'll show you 4 ways to convert numbers stored as text to numbers in Excel.  This situat...
5 Must Know Paste Special Tricks
Tutorial: The 5 best things you can do with the Paste Special command in Excel, with examples. Secti...

Excel Magic Trick #8: Text To Column

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.

Got a Question? Ask it Here in the Forum.