Tag Archive: Excel

Mar 13 2017

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

This fomula will count how many times a Specific Character Appears in a Cell…

For Books with Free Delivery Worldwide: BookDepository UK and USA

Jul 06 2013

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 your text is in cell A1, just enter this command in any cell, then copy the …

Continue reading »

For Books with Free Delivery Worldwide: BookDepository UK and USA

Mar 29 2013

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 be saved in the same original format? I am using the MS Excel Starter that …

Continue reading »

For Books with Free Delivery Worldwide: BookDepository UK and USA

Oct 04 2011

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 20% of the screen space. This would be very inconvenient on small screens, and I …

Continue reading »

Apr 03 2011

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. My original method was: Copy the date, paste it into Notepad, then select each comma, and press …

Continue reading »

Dec 01 2010

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 Microsoft Site itself at: Macro to extract data from a chart in Excel Maybe you …

Continue reading »

Sep 17 2010

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 of information, and about 600 of them ended with a comma, and the rest didn’t. …

Continue reading »

May 12 2010

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 I need to express it with an area code of 07 in front, and show the …

Continue reading »

Apr 20 2010

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 become 8,105 and 0:01:05 would become 65. Option 2: Change the cell format from the …

Continue reading »

Apr 20 2010

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.