Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel+courses - Splitting a cell
Resolved · Low Priority · Version Standard
Bridget has attended:
Excel Intermediate course
Excel Advanced course
PowerPoint Intermediate Advanced course
How do you split a cell so that the first name goes to one cell and the last name goes in another 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:Create your own custom list on Excel 2010!If you know how to use the auto-fill option on Excel then why not create your own customs lists? |
We'll call during UK business hours
Server loaded in 0.08 secs.