Similar to the TRIM() function but I would like to find a more automated way..
Thanks!

I'm still having trouble with this one.
I have a column of numbers from A1 downwards. In a second worksheet , I
have another lot of numbers in column A.
I need a formula which will tell me which numbers in Sheet1 are also

excel 2007
how can you copy a row then paste this row into multiple places?
TIA

I need to know how to convert decimal numbers that could at eny given time be
zero decimal places up to three decimal places  (ie 5, 3.5, 5.33, 12.713) to
feet and inches (ie 5'-0", 3'-6", 5'-4", 12'-8 1/2") this excel formula is
going to be linked with an AutoCad table can any ...

I have 85 worksheets all formatted the same - 4 columns and each sheet has
different row amounts.  I want to have one master spreadsheet with all the
information from the 85 worksheets.  Can this be done?

I have a spreadsheet that I'd like to copy over to another sheet EXCLUDING
any hidden rows/columns.  However, short of individually selecting the
unhidden rows/columns, when I select the area to be copied it automatically
copies all the hidden rows/columns.  Any shortcuts to help ...

I am calculating a 40 hour week payroll and need to lets say take data from
E8 thru K8 and have them add in S8 but if it goes over 40 to show only 40 and
the remainder in T8 whick would be overtime

I am relatively new to the more technical side of Excel and can't figure out
one particular issue. I have a large number of columns in my spreadsheet, but
some only need to be filled out if a particular value is chosen from a
drop-down menu. For example, if the user has the ...

I need to create seperate headers for seperate pages within one worksheet in
Excel 2000.

i'm trying to average 5 cells.  One has an #n/a value.  This causes the
average to say #n/a.  Is there a way to correct this?

I created a Pivot Table where everything works except for one column.  The
column show the size of products(1CT, 100oz....).  I have the field set up to
summarize by MAX.  I tried changing the format of this field from General to
Text but that did not do anything.  I also tried ...

I am trying to reference m pivot table on another tab; but am having issues
with the formula
=GETPIVOTDATA(SUMMARY!A5,$A$5,"Processor","Paula Brown")
What am I doing wrong?

I want a date format without the time stamp.  I have cell formatted as
mm/dd/yyyy; however, when I export to Crystal Reports, it converts to
date/time.  How do I strip the time from the date in Excel?

How can I extend the name of a column range selection.
Everything is fine with my formulas with Names but when I add rows, I have
to REdefine all my name range.
Alex

back in Excel 2003 I used an Excel feature that allowed me to import data
directly from an iSeries (AS/400) data file into Excel. It was a little icon
I had up in the toolbar. I can't find it any more and all import features are
talking about DB stuff I have no clue about. Any ...