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.
Questions about Excel Magic Trick #8: Text To Column
Want more info about Excel Magic Trick #8: Text To Column?
Get free advice from education experts and Noodle community members.