I am trying to use the Track Changes feature in Excel.  When I save a
document where I have turned on Track Changes, it loses the tracking.  There
is no evidence that the changes were being tracked when I open the file
again.  

I am looking for a function that will allow me to do the following:
I have the following value in a cell
Williams Sanders-IT Manager
I want to extract the "name" only from the cell.  Every row in this file is

I have created a worksheet that lists identification numbers for valves and
instruments on filtration machines.  Now these identification numbers are
unique because they are a combination of both letters, number and characters.
I need to find a way to check if any of these ...

Can anyone please review and correct formula to work for me. Unable to get it
right. Too stumped to continue. Ready to pull last hairs out....
=IF(AND(K20:K632="450300",N20:N632="SM1-Assy",N20:N632="SM2-Assy"),O20,)
Thanks

In Excel I have the option to go to Data - Text to Columns to convert text
from a single cell to multiple columns.  I would like to convert the text to
multiple rows.
----------------

I am tracking registrations for classes in an Excel sheet.  Each class has
multiple pieces of information - title, date, time, location, etc. - in
separate columns.  Is there a way to link the cells so that when I enter (for
example) the course title the other information is ...

I need a cell to allow only a certain number to be entered such as a 2 or a 0.

I am trying to write this in excel can someone help me with this. I have
tried the if and but no success.
The criteria are as follows.
Handicaps.  3 scores are used with the oldest score dropping

How to switch ON the option of obtaining the total number of filtered records
when using Autofilter in Excel?
In Excel, when using Autofilter option, I can read sometimes in the satus
bar the number of filtered records. Often this information is missing in the

i tried asking this in an earlier post. i'd like to write a function that
will look for a certain digit in one column of a worksheet, and bring
information from corresponding rows in a different column. i don't want to
count the number of occurrences, but display a list of them ...

I was a value in a cell  to represent the name of a range that I want to use
in a formula. Is there a function or way to do this in excel without VBA?

I have several spreadsheets that when I click the upper left hand box to
apply formatting to the whold document such as shows outlines, my document
will print out and then I'll have several pages that are blanket with just
the outlines printing. I have one document that is 5 ...

I am using this formula:
{=IF(ISERROR(AVERAGE(IF(Sheet2!$A$5:$A$58=Sheet3!$A5;IF(MID(Sheet3!$B$4:$K$4;5;2)=Sheet3!B$4;Sheet2!$B$5:$FF$58))));0;AVERAGE(IF(Sheet2!$A$5:$A$58=Sheet3!$A5;IF(MID(Sheet3!$B$4:$K$4;5;2)=Sheet3!B$4;Sheet2!$B$5:$FF$58))))}
This is Sheet2 (my data)

Is it possible and if so how, to connect two system databases on two servers
into one MS query?
It's possible in MS Access but I don't know how in MS Excel!
Suggestions please...

I'm using this macro:
Range("A2").Select
   Selection.Copy
   Sheets("TMS").Select