Reverse Last Name & First Name With Comma Using One Formula: Google Sheets
Recently I had a column of names in a spreadsheet with the following structure: Last Name, First Name and they needed to change to the structure: First Name Last Name. …
Recently I had a column of names in a spreadsheet with the following structure: Last Name, First Name and they needed to change to the structure: First Name Last Name. …
I recently had an exercise where I needed to extract all the text from an OmniGraffle document. The task at hand was to check a beautifully designed organisation chart against …
One of the first formulas I started with when exploring more about the functionality of spreadsheets is the IF formula. The IF formula is easy to understand and contains only …
How do you check if a cell is empty or blank in Google Sheets? There is a handy function called ISBLANK which enables you to check if a cell is …
Recently, I had an issue where I needed to calculate the age of a person at specific dates throughout the year. Using a Google Sheet, I thought I could simply …
The COUNTIF function in Google Sheets is a simple function which allows for the user to count a range of cells according to one specific filter. If more filters are …
In Microsoft Word you can control whether or not you want to see the white space characters in your document. This helps to check you haven’t incorrectly inserted a tab …
Very similar to our previous article on how to make a header row in Google Sheets, in this article we’ll show how you can lock a column in Google Sheets. …
I was recently working with a lot data on my Google Sheets spreadsheet and as I scrolled down the page the information from the top rows moved off and I …
In a previous post, I explored how to ignore blank cells when using the QUERY function in Google Sheets, which had its own distinct way of removing blank cells from …
A recent project hit a roadblock when I changed some code depending on the N/search module and refactored it to use N/query module. While I had some initial hassles with …
If you’re trying to debug a SuiteScript using the debug window within NetSuite and get the oblique error message: ReferenceError: Unable to find bridge [xmlApi], with parent [N/error]: ReferenceError: xmlApi …
Do you need to compress those large numbers in your spreadsheet down by representing them as thousands, or millions? This simple custom formatting technique will help you clean up your numbers real quick!
Do you want to install multiple Wordpress blogs on the one Bitnami Wordpress instance without using the Multisite instance? Step by step instructions show you how.
How do you find the difference between two dates in Google Sheets? Do you just subtract two dates? Or is there a handy formula you can use to better calculate the difference. In most spreadsheets there is a handy little function called DATEDIF (date dif) which can do more than just find the difference in days between two dates.
If you use Dropbox to sync your forex screenshots for later viewing you might want to use a more lightweight outfit for the task. Dropbox can bloat your Windows VPS and can also cause unintended consequences if you create more folders. Why not try a better, cheaper alternative with S3.
How do you send email through Amazon SES using SMTP? If you want to see how to send email using your custom domain registered with Amazon SES this article will show how you can by configuring your SMTP settings in Gmail.
If you’ve created your own custom domain and want to be able to create custom email accounts, but don’t want to register for a Gmail Business account due to cost …
How do you create a secure website using a static site? In this step-by-step guide using screenshots we provide a detailed description of how you can get an S3 site served through AWS Certificate Manager and Cloudfront.
How do you write code in Google App Script which prevents others from being able to edit? By creating a library which is attached to a Google App Script project you can circumvent the issue of having others accidentally edit your code.