Software

Ask something
Discussion Locked

Excel XP

0 helpful
3 replies

by tabcomputers2002

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Iim having a problem with sorting. My colum "A" is NAME and I have the names in first/last order. I need to sort the worksheet by last name. Without having to re-type it, is there a way to sort by LAST name? I used to have use Word Perfect, and I could just sort by cell 1, second word. How do I do it in Excel?

Thanks in advance
Tim

3 replies

by simy

You can separate the first/last name into two cells (col A and B) by selecting 'text to columns' in the data menu. This allows you to decide where the second cells starts. Once you have your names in 2 cells you can sort by the second column.

This discussion is closed to new replies.