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