I am using Office XP and need to bring a Word table into Excel. I have no
problem copying and pasting the table, but if a Word cell contains multiple
lines, every line in the Excel sheet has it's own cell.  Is there a way to
tell Excel to keep all text that is in a single Word ...

My Excel data contains both commas and tabs so I need to change the export
file.csv delimator to "~".  How can I do this?  (I tried Excel's suggestion
to go into the PC's control panel and change the txt list separator to ~ but
that didn't work.)

I have inherited a spreadsheet containing "records" that are split over two
rows.  For example:
A                 B           C                      D                      
E           F         G

I tried to use the hold-CTRL method to select columns on different worksheets
and graph them, but it doesn't work.
Any ideas?

Others will be using this workbook so I need to build in the ability to add
new names (lines).  I have a worksheet called "Names" and one called "Data".  
The name field (defined as a group) becomes a drop down box on the Data
worksheet for easier data entry (one name may have ...

I get a spreadsheet about 4.6 MB, and try to delete any useless formula for a
table A2:K1000, but I get no idea why the file size for this spreadsheet
increases from 4.6MB to 5.6 MB, which does not make any logical sense.
Will I create some garbage information when I delete those ...

Hope someone can help me with this.. If you have a Doc A listings names in
column A and you want each sheet name in another DOC B to be the names on the
list in Doc A. Is that possible with a formula? I know you can highlight all
the sheets in DOC B link to one cell in Doc A and ...

I am creating a curriculum based master calendar in which certain cells will
have multiple meeting times by different departments for the same day. I want
to be able to link one department (X) to Y document and (Z) department to A
document

When you protect a sheet On the PC Windows platform
you are given 15 to 20 seperate Check-boxs for different
things that you can Include/exclude..  How is this done on a
MAC?  When I do the Tools, Protection... ProtectSheet...

I am trying to color text white (to essentially hide it) if it meets a
certain condition.  However, it isn't as simple as if the cell =x.  My If
statement includes recognizing text.  =IF(H12="Independent", color text
white, color text black).  Is there a way that I can use ...

Dear Sir,
I understand that there is a download from MS for converting the format for
Excel 2007 in order for it to open and edit using Excel 2002.
May I know after downloading the format converter, the Excel 2007 file that

Is there a formula that would help me calculate the following:
      A         B
1  45,000    .50
2  50,000     0

I have a file that has multiple worksheets, each are protected (locked) with
a similar password for each worksheet.  Is there a way to unprotect all
worksheets all at once without having to click on each sheet and unprotect it
that way?  Is there a Macro?  Or something?

I am trying to set up a worksheet for a pipeline report.  I need to set up
Conditional Drop Down Boxes that are contingent upon the drop down Choice in
a previous Drop Down Box.  The problem is that I have to set up more than one
Dependent Drop Down Box for the same master Data ...

I have a spreadsheet called Book1 with 2000 lines.  
Where there is a dup in rate , name and month I want to remove the dup  
lines from the spreadsheet.  Keeping just one line.
If the price is diff but same month, name and rate i want to keep in the