98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel courses in - Excel - splitting cells
microsoft excel courses in - Excel - splitting cells
Resolved · Low Priority · Version Standard
Emma has attended:
Excel Intermediate course
Excel Advanced course
Excel - splitting cells
How do you split the information in a cell into two cells. For example a name .
Cell 1
spurle,emma
split into two cells
Cell 1
Spurle
Cell 2
Emma
RE: Excel - splitting cells
Hi Emma,
Simply click on the cell that has the data in it. Choose the Data menu, down to text to columns. Click in Delimited and choose the comma in this case and hey presto!
Let me know if it works
Tracy
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Missing Field handleIf your field handle goes missing all you need to do is go to tools > options > edit tab and then make sure that the check boxes for paste and insert buttons are checked. |