I am working with text files dumped from AutoCAD, the files in this case have
all the data for each special piping item. Each type of these items has a
unique identifier but may be used many times throughout the process plant. I
am compiling a list of these items showing how many ...

In the example below, how do I write a formula that will replace:
       the middle word in C1 with the word in B1
       the middle word in C10 with the word in B2
       the middle word in C19 with the word in B3

I have multiple pages on multiple sheets on excel.  Pagination is set up
under Custom Footers.  An extra page prints at the end of each "sheet", thus
throwing off the pagination of the sheets that follow.  How do I print only
those pages that contain information?

I have a spreadsheet that contains one set of cells that is time in and
another set of cells that is time out.
I have been able to calculate elapsed time in hours and minutes by
converting the time in and time out to military time.  Excel is reading this

hi members,
i used data validation on my data consists of mor
than 6000 rows when i clicked on circle invalidation entries there wa
message(your worksheet contains more than 255 invalid cells.only th

I am needing to find a way to 'extend a series' for an entire column with
multiple numbers without having to extend each series individually.  
Here's basically what I have:            Here's what I need it to look like:
345                                               345

I have a workbook containing 12 worksheets (1 per month), each contain a
table of 6 columns x 300 rows.  There are drop downlists in three columns and
i would like to create a printable report using vlookup to return data into a
thirteenth worksheet.

Can anyone 'in the know' advise how to add cell1 + cell2 + cell3 and
get a numerical result when cell3 may contain a word. Cell3 represent
postage and the word, if the order value is is high enough, would be
FREE.

I have two columns: Col C, yes, yes, no, yes, yes and Col D, yes, no, yes,
yes, Yes. I want to count on col D if it says yes and the coresonding cell
in Col C says yes. Thus I would like a formula to return a count of 3 for
this example.

1) I have a contact list for previous conference years. 1999-2006. I
want to find all the duplicates and have the duplicates pulled onto
either another worksheet or an area on the same worksheet.
2) I had to previously pull a random sample of potential duplicates for

Good everning:
Cells in my spreadsheet have numbers that are needed to identify file names.
I need to link the file to the numbers.  I used the hyperlink function, only
to lose the number.    The number is VERY important, I can't remember, won't

I’m trying to merge 3 workbooks to get a list of vendors with TIN, address,
last activity, last updated ID & last time updated etc and encountered a few
problems.  (One workbook has vendor name, last activity, last updated etc,
another vendor name, TIN etc and the last one vendor ...

I am setting up a model and in doing so I want to setup a dynamic lookup
command to streamline my work.  My model consists of 3 separate workbooks.  
Two of the workbooks serve as lookup tables (one for enrollment, and one for
residential development) to the the third workbook.  ...

=IF(SUM(G7-M7)>0,SUM(G7-M7)," ")
I love how this keeps the cells clean BUT because there is no value in the
cell, I cant calculate any further,
all I get in return is a #Value

After using the formula A1/24/60 (convert minutes to h:mm), when it exceeds
120 hours, it resets. How can I fix this?