Forum 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

ResolvedVersion Standard

Wed 22 Aug 2007, 10:02 Delegate Emma said...

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

Wed 22 Aug 2007, 12:28 Trainer Tracy said...

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 courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Copying the same value, label or formula quickly into a range of selected cells.

Select your range of cells. Type the value, label or formula that you want to appear in all the selected cells and then press Ctrl+Enter.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

microsoft excel courses in - Excel - splitting cells

Excel - splitting cells

RE: Excel - splitting cells

Excel articles

Excel tip:

Copying the same value, label or formula quickly into a range of selected cells.