software

I have a spreadsheet in which I have an annual rate of interest (b5 which is
5%), number of years investment (b6 which is 3) and a future value in b7

How can I drag a formula without incrementing both of the cell values stated
in the formula?

I have over 1,000 records in an address data base. The street address field
contains both the house number and the street name. I need to place these in

I have an excel spreadsheet sent to me that contains blank rows. Is there a
way to get rid of the blank rows with a formula so I don't have to go through

I've created some pivot tables that rely on the data source, but the range of
data in my data source changes frequently (not just the data in the range,

In earlier versions of MS Office/Excel, I have easily extracted as .gif files
charts that I created in Excel worksheets. Either I've simply forgotten how

VLOOKUP(lookup_value,table_array,col_index_num,ran ge_lookup)

I am trying to find a function or any other means to add up a row of numbers. The example is:

Over a year ago a member of this forum directed me to a web sight with

Is it possible to total the number of digits in a single cell? e.g. if a