I've created a spreadsheet with hyperlinks.
One of my hyperlinks says 'Click here to send this spreadsheet to....'
When I click on it it takes me to microsoft outlook with the email recipent
and the subject (as I had set these up in the hyperlink menu.

Dear Experts
Sheet1 has four columns from (column A : column D) and contains
following data
--date----weiht1----weight2------cash

I have below data in the excel from an import.
001-8420-849900
I want to change into 0018420.849900.  
I know how to replace "-" with "." but not sure how to delete one of "."

I'm using office XP home edition
How do I compose a formula within a cell that will perform calculations
using a number from  another cell.
So that when I copy the computed cell down and create a range of cells (by

I received the following inquiry from someone who uses Excel 2004 for
the Mac.  I can't replicate it in either Excel 2003 or Excel 2007 for
Windows.  Has anyone come across this issue in the Mac version of
Excel?

My menu bar (File, Edit, Insert, etc) is "shaded" or greyed out and I cannot
access them. I can add a command icon to the bar and access that. Happens
with no file open or with any file open. Any ideas?

I have an excel file that contains * in some of the cells (it was use
to denote specifics about a person, and is entered as *Smith).
I can not use find/replace to remove it because it is a wildcard, and
it removes everything in the column.  I can not find anywhere to

I have a macro set up that selects each worksheet and transfers data to each
one.  The macro selects the worksheet by name, so if I change a worksheet
name, the macro will not run.
I don't know much about arrays or dim'ing but I know this can be done.

I'm using Excel 2002 and trying to paste in a paragraph of text into a spreadsheet (worksheet).  The problem is that
it's showing up on a single line(row)  that goes all the way to column CK.  I tried formatting the beginning cell and
checked wordwrap but then what I got was  the ...

I have a huge list of patients identified by number... and columns of info
like gender, birthday, medical issues etc.  
I only need the info from 200 specific patients.  How can I isolate those
rows efficiently?

Does anyone have any suggestions on how to determine whether a list contains
a specific value? such as
{2, 6, 8, 16, 11, 9, 16} under column A
In cell B1, there is a value 3, if 3 is contained inside the list under

I would tremendously appreciate help in coding a deletion of all blank rows
from all worksheets in all files within a certain directory.
I have code that merges multiple documents but I found that any blank row
will stop the merge at that point.  The number of documents makes ...

i have a summary / calculation .xls document that used data from another .xls
document. i want to send the summary file to people via email but i do not
wish them to see the base data.
I am looking for a function similar to 'copy - paste as values' command but

how can I  e mail a single worksheet in excel 2007

I am hoping to create a WorkBook of 20-30 WorkSheets. Each sheet would
include a 5 column x 8 row table of various dates. I would like for a macro
to cycle through each of the sheets, looking for a user-defined month (eg,
June) within the table and, if found, print that WorkSheet ...