microsoft-excel-courses - spliting single cell

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

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

resolvedResolved · Low Priority · Version 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:

Counting Non Number Cells (Text)

If you try to use the COUNT FUNCTION =COUNT(Cell range)with a range of cells with numbers and or containing text fields you wil find that that the text cells will be excluded from the the count. If you want to include them try the the COUNTA FUNCTION =COUNTA(Cell range). This counts both text and number cell values.

View all Excel hints and tips


Server loaded in 0.11 secs.