— iIT-Services

Archive
Office

Powerful suite of software to run entire businesses with 45+ integrated applications. With Zoho one can manage, connect, and automate business processes across whole organizations: zoho.com.

Read More

Automated transcripts and translations in 40+ languages: https://sonix.ai/.

Read More

Remove the document protection from Word files without knowing the actual password (doesn’t work for files with password protection to open):

  1. Open the Word file in question (doc, docx)
  2. Choose “File”, “Save File As”, and make sure the file format is set to “Rich-Text-Format (*.rtf)”. Close the file in Word (important!)
  3. Open the new Rich-Text file with a text editor (e.g. Notepad or Notepad++). You can do so by dragging and dropping it into the editor window, or choose “File”, “Open File”, and set the file format to “All files (*.*)”.
  4. Find (ctrl-f) “passwordhash” and replace the string that follows with something else (e.g. “nopassword”). Save and close the file in your text editor.
  5. Re-open the modified Rich-Text file in Word, go to “Review”, “Restrict Editing” and click on “Stop Protection” (german version: “Überprüfen” – “Bearbeitung Einschränken” – “Schutz aufheben”). Uncheck all tick-boxes.
  6. Done. You’ve unprotected your Word file without ever knowing the password.
  7. Optional: Convert your file back to its original file format by selecting “File”, “Save As”, and choosing the original file format.

from: http://www.thinkoholic.com/2015/02/16/remove-unknown-password-protected-word-files.

Read More

Just a simple online text extractor. The text extractor allows to extract text from any image. One may upload an image or document (.pdf), from the device, a cloud storage, or an URL, and the tool will pull text from the image. Once extracted, the text can be copied to the clipboard: https://brandfolder.com/workbench/extract-text-from-image.

Read More

A (German) list of the top 100 open source software applications including some nifty little tools, by Computer Bild: https://www.computerbild.de/fotos/Software-besten-kostenlosen-Open-Source-Programme-herunterladen-3266766.html.

Read More

Extract key data from your emails, automatically. Integrates directly with any major email provider, tell Mailparser what data to extract and where to send it: mailparser.io/integrations.

Read More

I recently tried to have the custom date format in MS Excel

DDD DD.M., as of Mon 24.5. formatted on two lines in a single cell. That is, as:

Mon
24.5.

Aesthetisc of MS Office required me to implement this through formatting, instead of, e.g., using two cells with different formulas.

The solution was to use special characters, i.e., the line break character. Here, we’re talking about “ALT Keyboard Sequences”. Meaning: press and hold the ALT key while typing a sequence of numbers. For a line break, the sequence is “0010” or just “10”.

For the challenge above, in Excel, that meant typing DDD, then the ALT-sequence, and finally the DD.M. into the custom cell format. Interestingly enough, Excel makes a line break without showing the second (and further) line(s), but perfectly working as format.

The key sequences for any speical character can be found for example on https://tools.oratory.com/altcodes.html (EN) or also http://www.sonderzeichen.de/sonderzeichen_mit_alt.html (DE).

Read More