I often find symbols in MS documents I'd like to remove or replace with something else. Is there a way to detect the underlying code of a symbol or special...

I am no longer able to cut/copy a selection of data from one spreadsheet and copy it into another. Is there a setting or something that I have some how...

I have the following formula on one worksheet 240 times. Of course the formula is a bit different but the length is pretty much the same. Is there an easier...

Morning from a cold SA, sunny but temp is +- 10 deg C Need to show the dates from the Monday of one month to the Monday of the next month. This is for a...

Looking to change the format of an object...change the color of a circle to red if less than, yellow if between two values and green if greater than a value....

Is there a function to average a series of numbers but dropping the lowest ? Thanks, Yosef

I am attempting to upload a csv file but when saving I lose my initial zero in my spreadsheet due to the conversion to csv. I have tried EVERYTHING that I...

I'm using excel for years but today I was shocked. almost died. While summarizing a column of numbers, the summary was incorrect. I suspected that few cells...

What i want to do is dificult to explain so i'll try making a scheme. A B C D M N 1 9:30 12:00 ...

I would like to enter two lines of text in a single row (using ALT-ENT), but I don't want to merge cells. It's ok if the text spills across adjacent columns....

When I am working in Excel, I want to open separate excel windows when I open separate excel files. I used to have this function prior to Windows 2003. ...

Hi, I want to extract the 1st letter of each word in a string. So for example, in the string "my name is fred" I want to extract "mnif" the cell containing...

Does this make sense? As it is, I have sheets that get longer with each new entry. There is a formula in just one cell in column G that I drag down every time...

I have seen how you can break out last word in a cell, but what if you have 500 cells in a column you need to do...for instance breaking out last name in 500...

I have created a workbook with password protected sheets and protected workbook but when I copy the sheets into a new workbook the protection is removed. This...

John Walkenbach has sample code that shows how to fill a listbox with unique items in a list. You can easily adapt this method of using a collection...

Does anyone know what it means when a cell containing a formula, displays a result that is wrong, but the correct value shows in the "Function Arguements"...

Was merrily working on a file, saving it, etc.. Now when I try to open it, it gets about half way (as indicated from the blue bar) and just sits there. When...

Hi, I recently constructed a large spreadsheet for a colleague which, amongst other things samples at intervals the number of staff available (that is not on...

Hi, is there anyway to have a formula which I have in a cell in the second row of a worksheet to fill down the entire column of that worksheet, until infinity?...