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

data sorting

ResolvedVersion 2003

Jamie has attended:
Excel Intermediate course

Data Sorting

How do i split the text in one cell. EG if a cell contains first name and surname, i want these to appear in two columns

RE: Data Sorting

Hello Jamie
Thank you for your question

Highlight the column with the names. Go to Data, Text to columns. Delimited should be selected on the first window. Click next. Select Space. Click Next. Click Finish. Then just run an eye over it to make sure its OK.

If this resolves your question, please mark it as resolved. If not, please reply with more information.

Kind regards
Cress

Tue 3 Mar 2009: Automatically marked as resolved.

Excel tip:

Shortcut fill a cell with contents from adjacent cells

Use Control + D to fill a cell with the data from an adjacent cell. This speeds up data entry and is a cool tip to share!


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.