I am trying to remove the dashes from between phone numbers in a spreadsheet and then place a one (1) in front of the number when the dashes has been...

I am trying to compare addresses from two different worksheets in a WorkBook. Worksht one D4:D7379 (Address line 1), E4:E7379 (Address line 2) and Worksht...

How do I get around the 7 if function limitation. ie. We use a spreadsheet to document a game we play. In this game there is 1st-10th place at the end. If a...

Using Excel in magic square research I created a lot of rather complicated matrix statements doing simple things, summing a skew line I need to pick each...

I am attempting to automate some documents in order to grab data which is imported into another Excel Spreadsheet. My forumla seems to work well until the...

I can not use the commands on my excel network because the commands are grayed out.

Is there any function that allows me to convert number into their equivelent in words? Please advise

Hi We are currently planning to create some reports and before we start on it we would like to know if excel has any limits on the number of work sheets. We...

Hi I have a work sheet with a number of years work by month and I would like to sum all the like months depending on user input. I can do this with a...

Hi I have an excel workbook were I have copied a worksheet from another file into. I have removed all referances that I could find to other workbooks, however...

Hello, I in Excel, i created a spinner from the Forms menu. That spinner points to say cell a100, while the spinner itself is in cell a1. When i copy the...

Wanted to know if any of you have experienced this, and if there is a solution: I established a spreadsheet using a number of different formulas for a number...

I want to make the first say 8 rows of the first page of a larger sheet to become the header. Presently they are a part of the main text or cell...

in my worksheet with text data in cells, all the cell texts can be seen in print preview, but not after printing, in some cells. other cells can be seen as...

I have a six page worksheet or workbook as a template. The top part looks like a header but is not because nothing come up in view header/footer. Presently...

I have a CSV formatted report, embedded in an HTML page that I'd like to automatically import into an excel 2007 spreadsheet. The page, requires that I log...

I have set up some command buttons to run macros. The buttons perform the macros fine, but each time we use the buttons, they move or change in size. How can...

hi all good people, As I am a new excel user and don't know how to work with formulas. My question is if two partners are running a small business and...

hi, My question is, if a sales person gets his/her pay on different slabs of target achieved than how to get the count of achieved figure by using a formula ...

Hi to all good people, I am looking for formula help that can save my life, My question is Target Achieved Percentage Payout 100cases ...