This will count how many times the letter ‘a’ appears
=LEN(a1)-LEN(SUBSTITUTE(a1,”a“,””))
This will count how many times the character ‘,’ (a comma) appears
=LEN(a1)-LEN(SUBSTITUTE(a1,”,“,””))… Read the rest
This will count how many times the letter ‘a’ appears
=LEN(a1)-LEN(SUBSTITUTE(a1,”a“,””))
This will count how many times the character ‘,’ (a comma) appears
=LEN(a1)-LEN(SUBSTITUTE(a1,”,“,””))… Read the rest
The easiest way to remove that annoying space that sometimes appears in the beginning of a cell in an Excel spreadsheet.
Just use the TRIM formula and it will remove any spaces that are not single spaces between words.
If … Read the rest
This page is intended to show how to take a WordPress XML file of posts, edit some sections and then re-save so it can be imported back into WordPress.
XML files can be opened with MS Excel, but can they … Read the rest
Microsoft Office 2010 Starter Edition is a free version of Office 2010 that is NOT available for download, but is now available pre-loaded on many new computers.
This starter version has advertising down the right hand side, taking up about … Read the rest
There have been many times that I have had a list of numbers separated by a comma, that I wanted to list vertically in an Excel spreadsheet, and had to use a very slow and tedious method to do this.… Read the rest
Quite often I find a number of website addresses embedded in my excel spreadsheets, and to get the actual URL to show has been a problem.
Today I decided to work it out.
My first port of call was the … Read the rest
One of those little things that sometimes needs to be done when working with many lines of information is the removal of an odd character here and there.
I was in just that position today. I had about 2,000 lines … Read the rest
Sometimes I need to convert Telephone numbers to a different format, and I use the following formula in my Excel Spreadsheet to get the result that I need.
Example:
I take an eight digit number such as 12345678 and … Read the rest
To convert a time (hh:mm:ss) in Excel
Option 1:
To convert a time (hh:mm:ss) in Excel, it may be easiest to multiply the cell by 86,400 which is the number of seconds in a 24 hour period.
eg: 2:15:05 would … Read the rest
To round up numbers in Excel, it is easiest to use the CEILING function.
eg: =CEILING(A1,15)
This will round up any number in cell A1, to the next highest multiple of 15.… Read the rest
