Sort Items within a cell

**JinATX** · 12-19-2012, 01:18 PM

I saw another thread, but coudln't follow it. So I thought I should re-post. I have data in a single column, single cells that needs to be sorted:

ID_NUMBERS_ALL
70000 (Household Income); 4 (Household Size); 4256 (State ID#); N (Female HOH); Y (Active Military)
Y (Active Military); 1 (Household Size); 334532 (State ID#); 56000 (Household Income); N (Female HOH)
Y (Active Military); 2 (Household Size); 35000 (Household Income); NA (State ID#); Y (Female HOH)

Needs to be sorted to (but in any order):
Y (Active Military); 4 (Household Size); 70000 (Household Income); 4256 (State ID#); N (Female HOH);
Y (Active Military); 1 (Household Size); 56000 (Household Income); 334532 (State ID#); N (Female HOH)
Y (Active Military); 2 (Household Size); 35000 (Household Income); NA (State ID#); Y (Female HOH)

Then I can split the columns to make the data sortable. I'm happy to split first, but can't find a way to move cells into the appropriate columns after I split.

Thank you for any help!

**dogberry** · 12-19-2012, 02:59 PM

Hi

Use your text to columns to split the information first then if you cant sort it upload a sample sheet you will get a much better response with that and remember to show on the sheet what you would like to achieve.

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

Chris