Sort Excel Data By Numbers and Text Properly

instead of: game 10 game 2 game 24 game 3 Use ASAP Utilities Tab "Range" icon Select "Advanced Sorting" from the menu Sort By: "Alphanumeric Content" Then By: "Value" to get: game 2 game 3 game 10 game 24

Advertisements

Output a List of Folder Contents to a Text File in Windows

From Command Prompt Change the Drive - "F:" Set the directory - "cd " Paste Folder Directory you want to Export the list from, as follows: (the two steps above can be done in reverse order to get the same result) cd F:\"Kalani's Folder\Kalani's Stuff"\ContentsList.txt Use " " around Directory after pasting location from Explorer … Continue reading Output a List of Folder Contents to a Text File in Windows

Converting Text Files From One Encoding or Operating System to Another

Unicode UTF-8 or UTF-16 to ASCII on various platforms LF = Line Feed CR = Carriage Return (FTP will change formats automatically in ASCII mode, but not in binary mode) To convert a Microsoft Windows file to Linux or a classic Macintosh file you subtract. To convert a Linux or a classic Macintosh file to … Continue reading Converting Text Files From One Encoding or Operating System to Another

Rename Text & HTML Files using text from within the Document itself as the New Name

Download Here: Replace Pioneer Instal & Run Tools> Batch Runner "Pick Files" Check the box Set Output File Name Type in ${FIRSTLINE}.txt into the box, or ${FIRSTLINE}{1,9} for only the first 9 characters, or ${FIRSTLINE}{lc}.txt for lowercase, Put a "$" before each class, for example ${FILENAME}${FIRSTLINE}{lc} will add the first line of text to the … Continue reading Rename Text & HTML Files using text from within the Document itself as the New Name

Recording a Macro for Saving Word Text or Pages to Individual RTF Files

Open the Document Record Macro Name it with no Spaces Assign Keyboard Shortcut, hit 'Assign' Close - Begins Recording Ctrl+F - Find Dialog Type a word or character in the heading that will divide each page (ex.Title, or .txt) **if every page fits on one sheet or two sheets, or any set number of pages, … Continue reading Recording a Macro for Saving Word Text or Pages to Individual RTF Files