VBA code to remove white spaces from a string in excel


VBA code to remove white spaces from a string in excel. Simple method is, use Replace() function.



VBA code to print a string in double quotes in excel


Below is the VBA code to put double quotes (quotation marks) for a string in excel. We can use CHR() function to print special characters like double quotes in excel VBA.

Example: Below is the VBA macro to print a string in double quotes (quotation marks (” “))


Easy steps to install Python on Windows


Below are the easy steps to install python on Windows (I tried with Windows 10). Install Python (Download it from http://python.org/download) on your C drive Search PowerShell from Start menu or Windows search box. Click on it to open. Type python in your PowerShell (Terminal) If you get any error or python is not recognized, then […]

Simple steps to install openpyxl on Windows

Openpyxl is a python library to perform read/write excel xlsx/xlsm/xltx/xltm files. Below are the simple steps to install openpyxl on Windows Click below link to download openpyxl package Download openpyxl package Extract the downloaded TAR file (recommended to extract it to python folder on C drive) Open command prompt or Powershell Navigate to the folder that you […]

16 steps to record desktop screen with YouTube


To record computer screen and upload it to YouTube, normally we follow below steps Download and Install a screencasting software Click on “Record” button to record selected desktop screen Upload the created video to YouTube But, in this article, im going to explain how you can record desktop screen with YouTube, without using any desktop software. For […]

Page 1 of 812345...Last »