microsoft-excel-courses - Spliting a single cell

The UK's most regular instructor-led training courses.
Training information: microsoft-excel-courses · Microsoft excel training · Microsoft Excel Training UK
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Spliting a single cell

Kassandra has attended:
Powerpoint Advanced course
Excel Intermediate course

by - delegate Kassandra [3 posts] (2007 Jul 31 Tue, 13:19) Reply

How do i split a single cell within a worksheet?

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 25 Tue	Bloomsbury	0	FULL
2003	2008 Nov 27 Thu	Southwark	3	book now	£210	£215
2007	2008 Nov 28 Fri	Bloomsbury	0	FULL
2003	2008 Dec 2 Tue	Bloomsbury	4	book now	£207	£215
2003	2008 Dec 4 Thu	Bayswater	6	book now	£195	£205
2007	2008 Dec 8 Mon	Bayswater	5	book now	£212	£224
Full Schedule: See all 113 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: Spliting a single cell

by - trainer Tracy platinum contributer [586 posts] (2007 Aug 1 Wed, 10:04) Reply

Hi Kassandra,

Thanks for the question. The honest answer is you cannot split a single cell, as a cell is the smallest entity you can get. However there are ways of breaking down information into different cells, if that helps. Please let me know what you had in mind so I can see if I can find alternative methods for you.

Tracy

· Do You Really Need Excel VBA Training?
· A Beginners Guide To Formulas In Excel
· Compare Different MS Excel Training Methods
· Why Should I Learn Visual Basic in Excel?
· 3 Reasons Why Excel Training Courses For Employees Can Improve Your Business

Excel tip:

Recently used file list

Under the File menu, you may find a list of files at the bottom of the menu. These files represent the most recently used Excel spreadsheets. This file list provides a quick way for you to access your files.

You can disable the file list feature of Excel. This is done by

1. Choose Tools > Options menu. You will see the Options dialog box.
2. Ensure the General tab is selected.
3. Make sure the Recently Used File List check box is cleared.
4. Click on OK.

View all Excel hints and tips