2011. március 28., hétfő

How to replace accented characters in Excel?

If you ever tried to generate user names and / or passwords from names with non-ASCII characters (accents, diacritical marks etc.) you had to find out that there is no function for that. I have only found solutions using macros.
I refrain from writing macros: I think anything that cannot be solved in an Excel sheet should not be, rather it should be programmed in a proper programming / scripting language.
Here is my 1 minute solution for that:
  1. The first two rows of your sheet should Start with From: and To: (see the screenshot) You should put the characters to replace in the first row and the accent less versions right below these.
  2. The first column below this should contain the original text to convert.
  3. Put this function right below the From and To rows, right of the first line of text to convert (third row, second column):
  4. Copy this function to the right (under each character to replace) and to all lines (which have text to fix).
Your last column is the all fixed text. :)

  • replace spaces, eg. From: " " To: "." like in the example.
  • You can also use this to delete: replace anything with empty
  • You can also use multiple letters (replace/ delete words, eg. change ß to ss and so on)
Have fun, let me know, if you need help! :)

2011. március 22., kedd

What to do, if you cannot connect your Nokia Phone to your PC?

Have you spent countless hours trying to connect your Nokia phone to Nokia PC Suite or Ovi suite, getting errors when Windows is trying to install all the different drivers.

This solution worked for me from Nokia Support Forums:
  1. First insure you either have Windows Media Player 10 or 11 installed
  2. Download Microsoft Media Transfer Protocol Porting Kit from: Here 
  3. Once downloaded and opened the files should extract to by default C:\WMSDK. If so navigate your self to C:\WMSDK\MTPPK12\Tools\DirectMTP and extract the zip file relevant to which version of Windows Media Player you have installed and your operating system.
  4. Once extracted navigate through the unzipped directory 2 folders in (they repeat the original name of the extracted folder.
  5. Once among list of files you shall find a file named mtpinfup.exe double click it and a command prompt window should appear briefly then disappear.
  6. Right click my computer, click manage, then select device manager and select the MTP device that is still unknown; right click it, select update driver OR: disconnect, wait and then reconnect your phone.
  7. Allow it to automatically scan for the drivers and install them correctly this time.

Rendszeres olvasók