i am not able to replace the space in cells
ex: i have a data range of a1 to d90
in that all the cell have the spaces at the end
now i wanted to remove all those at a time

is there a function that will return the first non-zero cell in a given range?
For example, I have a range of 20 cells in a row (say column A through
column T), and I want the function (or seried of functions) to look within
the range and return the value furthest to the right. ...

I will try to explain this the best that I can...
I have around 100 excel workbooks that contain the same exact sheets in
each.  In each of these worksheets there are cells that contain a number
value that I would like to total on one 'master' sheet.  These workbooks are

they forgive to put this formulates not this helping, We go to try galera
debtor
When I am rounding off the numeros, I have necessity that they are always in
multiplos of 5 in 5.. What nao happens. sees...

Hi
I have been task to find a formula to be able to count peoples ages into
select different age groups for a quartely report.  The age groups i have to
catagories them into is 18-21 , 22- 31, 32-41, 42-51, 52 -61 year olds

I don't know if there is a way to do this but if anyone can tell me, it would
save me days of work.
I have 2 sheets, one with many columns of numbers but one column with
identifier numbers (Sheet 1, column a) and anotehr sheet with with 2 columns

Dear friends & members
I have a data on 1 single sheet in the below form (just an example) in
which 1 cell shows month, second shows name and third shows again
result my problem is that i want the total result in another form

I create a Budget every year.  I use the previous year's Workbook and 'Save
As' the new Workbook name.  I can't seem to get rid of what appears in the
Header/Footer.  I've tried many different scenarios including: 1) deleting
the info, then do an immediate 'Save.' 2) saving as a ...

I have a starting rent amount (like $25).
I assume 3% growth in the rent amount each year.
I have a lease term (like 55 months).
Rent       Term     Ave. Rent

I cannot select the compare and merge workboos button on the toolbar. I
re-drug it to the toolbar again and the same thing happened. I can't
select/highlight/choose it.

Okay, this is somewhat backwards but it is a necessary evil...
I have data that goes like this:
Transaction Date   Location Account   Amount
10/06/2006               1           200        $300

I have two columns one(A) with continuous data from top to bottom, the other
(B) with simular data only dispersed randomly  from top to bottom.  What I
would like to do is replace the data in column A with the contents of column
B, only when there is data in the cell in column B, ...

Because I am studying in depth the array formulas, I would like to
know if it is possible to build a formula such that, given a set of
numbers in a vertical range (1 column wide), it returns an array with
the cumulative sum.

I am trying to lookup a persons name in a table. Then return ALL the rows
that are associated with that name.  HELP.
IE:
Sheet1-A2 has the name I'm looking for

I'm hoping an expert can help me here. I have a sumproduct formula that
isn't working the way I expected it would. The first part of the function
correctly returns '8' and the second part correctly returns '27' but I'm
looking for these two results to sum to 41 and instead I get ...