Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

microsoft-excel-courses - spliting single cell

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft-excel-courses - Spliting a single cell

microsoft-excel-courses - Spliting a single cell

ResolvedVersion Standard

Kassandra has attended:
PowerPoint Intermediate Advanced course
Excel Intermediate course

Spliting a single cell

How do i split a single cell within a worksheet?

RE: Spliting a single cell

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

Excel tip:

Create a unique items table from a duplicating table

1. Ensure that your list has column headings
2. Select the entire list
3. From the menu bar, select DATA, FILTER, ADVANCED FILTER
4. Select "Filter the list, in place", and tick the "Unique Records Only" box
5. Click OK, filtered list appears.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.