I have an excel worksheet with a street name column.  I need to
rename some names from "Main Street" to "Main St".  I can do it for one
name easily with find and replace, but how do I make it work for an
entire column of different names such as "Easy Street" and "Main

Trying to concatenate data that is imported in a file but having a problem.
.Offset(0, 2).Value = Right("0000000" & myID & "h", 4)
Data       Want          Get
2C0         2C0h       2C0h

I'm missing something simple, but I am trying to get a value (displayed as a
percentage) in one cell, using the cell next to it as part of the equation.
The problem is that the second cell is displaying a value from an equation
that's built inside of it and when I use it for the ...

I received the answer on assigning consecutive dates but what can be done to
the formula
=INT($A$1+INT(ROW()-1)/30)
TO:

I need to sum COLB if COLA = BOX549 or BOX980
BOX549    70601
BOX919    60254
BOX017    45468

Im trying to make a custom function but I seem to unable to make the
correct declaration
I have the code below but its not displaying the data that I want
The result should be Lynn Haven for C410 data and ABU for G538.  but it

When you give a cell a name it defaults to absoute reference.  Can you change
the reference from absolute to relative.

I have information on a data page like the following
 A         B         C
8-15   10-16      99
8-16   11-24      98.7

I would like a formula to count how many cells contain a code that begin with
B, then with Z and O.
So B's would be 3   Z's 5 and O's 1.
1   BBL

I want to formulate a list of value that are in column A and not in column B.
I'm comparing 2 lists of employee IDs. I'm going to do this many times, so
the exact number of IDs in either column will change. I don't know if this
makes a difference or not.

I have a long list of numbers is Column A; I have a second extra long list of
similar numbers in column B. How do I play find your Mate? M001 in Column B
finds M001 in Column A. What if my Column B list has more than 1 M001? Will
that effect the outcome?

I have a cell, M30, in which I want to display contents copied from another
cell (D18), provided that two different conditions are met:  K24=Y  and M29
has some text content in it already.  Otherwise, M30 is blank.
The basic IF statement I've written for M30 is    =IF(k24="y",D18 ...

I would like to use the value of a cell, in this case a stock ticker, to
refer to another worksheet that is named identically. For instance, I have a
cell value UPS and a worksheet named 'UPS', I would like to pull a value, say
D21, out of UPS! without hard-coding UPS! into my ...

I have some problems, of course.
first problem: english is not my main language so sorry for any typos.
second problem is a excel problem:
I have a table with say 300+ prices, I would like to increase all th

Hi all:   I am creating a report/graph combo.  here is my issue.  I am
summarizing a list of data and using that summary to create the charts.
I would like to insert daily a line to this table but have it only
calculate the last thirty days.  As I add a line EXCEL adjusts the