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

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
excel+courses - splitting cell

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel+courses - Splitting a cell

excel+courses - Splitting a cell

ResolvedVersion Standard

Bridget has attended:
Excel Intermediate course
Excel Advanced course
PowerPoint Intermediate Advanced course

Splitting a cell

How do you split a cell so that the first name goes to one cell and the last name goes in another cell.

RE: Splitting a cell

Comma Delimited Text

Highlight the range of cells where the first name and last name is, then select data > text to columns...

then when presented with the dialogue box, choose the top option, which says 'delimited', then click next.

After that, select the box that says 'spaces' and de-select any other boxes that may be ticked and then click next, then finish and voila!

There you have it...

Hope this helps

Paul

Excel tip:

How to Spell Check an Excel 2010 Worksheet

Excel 2010 does not automatically spell check a document. So, here's how to manually spell check a worksheet.

Either select the ''Review'' tab in the Ribbon, go to the ''Proofing'' section and click ''Spelling.'' Or, simply press F7.

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.09 secs.