i am trying to add a blank row after i compare 2 #s in a column.  i am using
the if statement to compare and if they are not = then i want to add a blank
row in between them.  any suggestions?  i am having a real time trying to get
this to work out.

I have a simple formula multiplying two cells and the ouput is incorrect. Why
is this happening?

I am trying to combine 3 tables together that are all in separate worksheets.
They are all simple, no formulas, macros or anything.  The problem is that I
have some cells that contain a lot of text (product descriptions).  When I
paste the table in, it only keeps the first 255 ...

have listing of stores and weekly sales, want to calculate the last four
weeks moving average, e.g, this week (wk4) would be weeks 1-4, next week
(wk5) would be weeks 2-5 and so forth.
second caluculation would be to rank the stores by weekly sales on same four

When I try to do a web query data connection into excel (which I do
normally with other web pages) to a page with flash I get the following
behavior:
-- the dialog box that shows me the web page for formatting into excel

I need to process tables containing somewhat ambiguous data.
Briefly, I want to replace specific positions in a cell
by a "wildcard" character if certain conditions apply.
Let me illustrate and I apologize for being verbose!

While attempting to convert text to columns one of the columns is dropping a
digit and adding a 0 to the number.
2008135701620201 after deliminating and sorting to columns this number
appears as 2008135701620200 even though it appears correct in the import text

I'm trying to resize an individual cell, but all i'm able to do is resize the
whole column or row. Can you resize just one cell and how?

I want to add dashes in a cell which has both number and text. for example, a
cell contaion 10G101211100011 and i want to change it to 100G-1012-1110-0011.
Is there a formula i can use?

I have problems sorting a sheet with 2o ooo rows and 25 columns.
Whether I try with or without header it ignores the data.
I can do it with approx. 2 ooo rows without problems
Any reason and ideas?

How I can make the cell stopped where it is when I press enter I don’t want
to move the sell down when I press enter I know it’s a silly question but
this is a very useful at work
Many thanks

I have two lists of names in two separate worksheets.  Both worksheets are
set up so that Col A contains the last names and Col B the first names.  I
need to delete any names in the second worksheet that are not in the first
worksheet.  I do not want any changes made to the first ...

I am trying to create vba code to sort multiple sheets by clicking on a
command button. I got it to sort the first page correctly, (the page the
button is on), but I'm having trouble getting it to sort other pages. I get
this error: "Method 'Range' of object '_Worksheet' failed."

Basic Explanation:
I use excel to break down stock market data into charts for analysis.  Over
time I have linked many spread sheets in an extremely tangled web of mixed up
data.  I have many charts in one spread sheet that may have been created and

1)  I bid projects that require me to list hundreds of unit prices in "BOTH"
words and figures.  I know there's a formula that can create the figures "in
words" from a numerical cell value, but can't find it.  Help save me from
writer's cramp!