TL:DR; Append data in a block of cells with one another to create one row or column in MS Excel.
Append data in a block of cells with one another to create one row or column in MS Excel.
Import one or many text files into a blank OO Calc file. Specify local text files and either insert them all into one sheet or individual sheets per file. Each line of the text file can be chopped up by a specific character to create new Calc columns
Quickly clear out text and spaces for cells in Excel using numerous methods. These methods include: removing spaces, removing alpha, numeric and more, removing characters after a word, removing characters after a certain position.
Convert units of measure in MS Excel. Convert length, weight, volume and temperature. Units include: inches, centimeters, millimeters, miles, kilometers, meters, yards, feet, pounds, kilograms, fluid ounces, ounces, grams, tons, quart, gallon, liter.
