Excel: How To Count How Many Times A Specific Character Appears In A Cell

Counting the Number of Times a Specific Character Appears In A Cell.

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

Counting the Number of Times a Specific Character Appears In A Cell.

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


ai8
Agoda HolidaysAgoda HolidaysThese Adverts help to pay for this site. (ai8)

How to Remove the First Character in a Cell if it is a Space

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


ai8
Agoda HolidaysAgoda HolidaysThese Adverts help to pay for this site. (ai8)

How to: Edit an XML File and Save the new XML File

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


ai8
Agoda HolidaysAgoda HolidaysThese Adverts help to pay for this site. (ai8)

Microsoft Office 2010 Starter Edition Download

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


ai8
Agoda HolidaysAgoda HolidaysThese Adverts help to pay for this site. (ai8)

How to change a Comma to a Carriage return in Excel

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


ai8
Agoda HolidaysAgoda HolidaysThese Adverts help to pay for this site. (ai8)

How to Extract hyperlink addresses in Excel data

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


ai8
Agoda HolidaysAgoda HolidaysThese Adverts help to pay for this site. (ai8)

How to remove last characters from Excel spreadsheet cell

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


ai8
Agoda HolidaysAgoda HolidaysThese Adverts help to pay for this site. (ai8)

Converting Numbers in Excel Spreadsheet

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


ai8
Agoda HolidaysAgoda HolidaysThese Adverts help to pay for this site. (ai8)

How to convert Minutes and Seconds to just Seconds in Excel

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


ai8
Agoda HolidaysAgoda HolidaysThese Adverts help to pay for this site. (ai8)

How to Round up in Excel

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.


ai8
Agoda HolidaysAgoda HolidaysThese Adverts
Read the rest

ai8
Agoda HolidaysAgoda HolidaysThese Adverts help to pay for this site. (ai8)