Is there any way to count characters (spaces included) in a cell to insure that the characters in a specific cell do not exceed a preset number? Thanks...

I receive spreadsheets with data from a number of different sources, in different formats, but with essentially the same type of information. I need to name...

Hi, I would like to extract the total number of pages of an Excel file in a cell so that it is updated automatically. I need to mention the total number of...

Hi, I'm using Excel 2003 and I have a spreadsheet which I have set up so that 'gridlines', 'black and white' and 'draft' are unchecked. The cells where...

I used to be able to click on the graphics selection tool in office 97 on the left end of the drawing toolbar then click and drag over multiple graphics to...

I have close to 1000 entries in my Excel spreadsheet, and am trying to figure out why entries are coming up missing. I often do custom sorts. This may be...

Someone has changed the settings on my computer so that every time I enter anything in a cell, the computer speaks what I typed in upon hitting the enter...

I have a sheet that contains 20 tasks that have a column that ranks their priority 1 thru 20. I need to be able to take task 15 and change the priority to 3....

The following formula will not work and for the life of me I can not figure out why: =if(isna(match($a2,$e$2:$m$7,0)),$a2," ") In cell a1 is the text "All...

I am using Office 2007. In Excel, I like to write a code in Visual Basic to copy the contents of the cell above into a blank cell down below and repeat the...

I'm looking for a formula to lookup criteria in column A and add the results in columns B, C, D, E, etc. For example I would like to know the sum of how many...

In a table, i have one column (let say Column A) where the formula is referred to another workbook. The formula works well, until i do an auto-filtered on...

I am trying to figure out the formula for adding the nth cell in a given column. I am using the formula below to add every 4th cell but it is just one that I...

Hi , I am doing a mail merge, on e for the fields is a weight which displays as ..425. When i do the merge this field displays as .4251111333300000 or...

In Excel 2003, how can I change the colour that track changes displays in? At the moment changes are showing up in Navy which is not easily identifiable...

I have a column of #s and a column of text. The column of text describes the column of numbers. I don't want to have to retype either column. Is it...

Can someone please advise how I can have Excel on top of any other programs I have open at all times?

I have created an invoice on an excel spreadsheet for a new business and my plan was to use a sales list on another sheet linked to the invoice , using the...

How do I rearrange data by dates in reverse order? Example: I'd like to change the order to 3/21/2010, 3/22/2010, 3/23/2010...etc. Current order Column A ...