I have a user who is using a formula which has reached the 1024 limit. Can
this formula be split up into two cells? Or can I use VBA to re-engineer the
formula?
Any formulas in VBA would be appreciated or any other suggested work

I use excel to pull quotes off of MSN Money (it comes with that option).
However, alot of quotes on obviously valid stocks (including ETFs) don't
come up.
For example, ticker IWD is the ishares russell 1000 value index.  EWW is the

I have a large spreasheet that reads as follows (In three col) The list is
sorted on Col A
No       Name       Amount
1        John           29

I have a number of excel files in a folder that need "Text to Columns" in
Column A. The files are all formatteed identically, with different data. Is
there a solution for this?
I'm using Excel 2003 on Windows XP.

I'm using Excel 2002 for the first time and trying to place a function into a cell.  I 'm using IF(N44=L, M44-L44, L44-M44)  .
Which is supposed to mean If the letter L is in cell N44, then subtract number in L44 from number in M44.  Otherwise subtract M44 from L44.
If have 2 main ...

I have set up a simple database in excel, using barcodes (i found this
easier to scan and lookup, than access) plus the people working with
this will find it simple to use. I have however reached a giant full
stop.

I want the following code attach to a commandbutton.
Sub Rij_Invoegen()
 ActiveCell.Offset(1, 0).EntireRow.Insert
End Sub

I use Excel 2000 to display data extracted from DB2 via SAS.
Worksheets use the Autofilter feature on all 45 columns and about 20 of
the columns are summed at the bottom.  There are also 4 hidden rows
below the 'main' data, which is used in the QA process.

Application :MS Word
I am creating a word document.In Table of Contents page,I have 5
sections.I want to create a hyperlink so that if I click the section 1
,I should be able to go that page (for example page no 23).

It was suggested that to get the spelling facility on Excel worksheet, I
should go to Tools and remove the tick against Standard, which I did, but
how do I get back to Standard when I do not need the spelling facility?

Hi again all, I just had some really awesome help which would have taken me
months to figure our myself, so I thought id try my luck a 2nd time and see
if I can find the solution to another problem I have,
Ive got a sheet, and its got the followings format,

I have the value of  $27.52...I need to convert it into 00002752.
Any help would be greatly appreciated

I have converted an XLS file to EXE. The file is more for information
rather than for data entry or changing values that need to be saved.
I can now double click the EXE and it will start Excel with a copy of
the XLS file.

I have a spreadsheet that is regularly upadated overwriting columns,
however I need to enter comments on the sheet referenced on the
content.  The next time I update the sheet the referenced cell will
move down a row, but I need the comment to stay with the content rather

How many MATCH commands can be added in one formula?
I got an error while I double check this long formula, particulary the
( and ).
"The formula.... contains an error..."