I have the new Excel 2007 and I need to insert a column to the left side of a
column of cells that I have selected.  How do you do this?

I have times imported into excel from my handheld. The times are put into
the handheld as 13:30 for 1:30PM. After inputing 13:30m 1:30PM automatically
shows up in the appropriate cell. After synchronizing to a spreadsheet on my
desktop I can't subtract one time from another. I ...

I need a formula to find the position of the SECOND occurrence of a character
in a string. I can find the first occurrence using the FIND function no
problem but I have no idea how to find the position of the second occurrence
formulaically. Is there a formula to do that without ...

A mileage claim form is used.  Drivers get a certain rate for mileage driven
up to 1,000 miles, at 0.40 pence per mile and another for over 1,000 at 0.25
pence per mile.  I have set everything up to record the accumulative miles
each month, but can’t split the monthly figure into ...

Hi! I have three columns: A, B and C. They all contain credit rating
information in the form of a grade (eg. AAA or AA-). I want to check the
ratings in column A, B and C and then get a final score in column D. The
rating in one or more columns can be empty. If there is only one ...

I am trying to get a list of print jobs from event viewer scaled down to
just show what I want.  I currently export this info into a spreadsheet
A 3/14/2007
B 8:09:21 AM

I have both text in some cells and numbers in others across a row and
want to find a formula that will allow me to determine I
pre-determined criteria matches each other across the row, then retur
the result of the next cell in the row. For Example:

I need to write a conditional statement that does the following:
If  the result of <formula> = a whole number, then <formula2>, else <formula3>
I have all the formulas working I just don't know how to writeup that first
condition, if the resulting value of the formula is a whole ...

I posted this over in misc, but no one was able to help me there.  Maybe
here...
I have been asked to create a worksheet (file 1) that displays selected
table row information (row-by-row) from a second file (file 2).  (The column

Here's my sumproduct formula:
=SUMPRODUCT(--(Data!$F$2:$F$2500='BDC P&L'!$C$607)*(Data!$D$2:$D$2500='BDC
P&L'!C608)*(Data!$A$2:$A$2500='BDC P&L'!$C$605)*(Data!$C$2:$C$2500='BDC
P&L'!$B612)*(Data!$E$2:$E$2500))

I have activated the 'Analysis Toolpak' add -in, but many financial functions
are still not available - such as nominal and effective formula conversions.

Site#    Serial#    No. of times repeated
205    12345    4
205    5678    5
205    54785    7

I have inserted a picture from a file into excel and I want the picture to be
like a watermark and show up in the background but allow the ability to see
text over the picture. When I insert the picture and right click and send to
the back it does not fade into the background. I ...

I have 2 reports that i use in my department.  1 report lists names but it
has an extra space after the last name:  Doe , John
The other report does not have the extra space:  Doe, John.
The report with the extra spaces has been used for a long time and many of

I have a list of customers in an XP spreadsheet, some may be duplicated.  I
would like to copy the list to another worksheet, or below the current
worksheet, eliminate duplicates, and get a count of occurrences of each
customer.  I don't know if i need to use COUNTIF, FREQUENCY, ...