DatabaseRobert
Level 5

I would not append 0s (That just turns "16" into "000016", and you still have things sorting in numerical order.)

What you need to do is:
 - replace "=" with "tab" (will put the forms into their own column);
 - bring your two text columns over into a column to the RIGHT of "A";
 - copy the left-side column (the Lacerte variable) AND THE COLUMN TO ITS LEFT back into your clipboard over to your text file;
 - replace "tab" with tab' (tab followed by an apostrophe, forcing that cell to be "TEXT");
 - re-copy those columns back over to your spreadsheet.

You now have your blank column that you skipped when pasting in the first time, and you have TEXT ENTRIES for the variables, and then you have the form names.


Now when you sort, you should get them in alphabetical order, not numerical.



Robert

0 Cheers
Reply