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...
ChatGPT to Excel - The Easy Way
Tutorial: How to export fully formatted responses from ChatGPT into Excel with this one simple tric...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course




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.