in Excel 2002, I have a column of data that includes a "" symbol, followed by numbers. I want to get rid of the "", and keep the number in that cell. The...

Is there a way to sort a row in Excel to sort a number of cells that have multiple entries and view a list of just one occurrence of each different types in...

In Word the shortcut keys to change from UC to LC is shift F3, why not have the shortcut keys to do the same in Excel?

Hi, I have all of my personal addresses in an AnyTime file. I have exported it as a .csv file. I then open Excel and when I try to import it, it says cannot...

Eu tenho uma planilha Excel em que várias linhas não tem conteudo. Como marcá-las de uma só vez para exclui-las. Lembrando que as linhas a serem excluidas...

I have a Loan-To-Value formula referring to cell c13(the property value), c14(the loan amount), and c17(the Loan-to-Value). The formula in c17 of course...

I'm creating an Excel Book with several worksheets. As with a lot of the information on the woorksheets I am trying to automate the data entry to cut down on...

I am trying to create a macro that will allow the user of a spreadsheet to only view specified columns. It is easier to describe using an example: 1/05 1/05...

Hi, I want to use the following formula at the bottom of a column of inputs: =IF((D14+D15)1,((D14+D15)/-2),"")+IF((D16+D17)1,((D16+D17)/-2),"") ...

I have a worksheet with two columns of data Column A has contains a reference code, d1, d2, d3....and so on to d6 however, this code can occur more than...

Hi Looking to find a formula that will calculate a maximum bid figure from an array. Example data. Products Bidder Amount Product 1 John ...

I know there should be a simple answer to this question, but I can't find it on the "Help" menu.

Our database represents dates by giving the day number within a year. For example, day number 1 is January 1, and day number 365 is December 31. Is there a...

The & sign comes out when you do this. I can understand due to the functionality, but there has to be a way to have an & sign.

I am trying to give an hyperlink in the excel sheet, which refers to a particular section of TOC in a word file.

Hi all, when i try to create a copy of a worksheet from one workbook to another i get the following error message :- Microsoft Visual Basic file not found:...

Assuming the date entered is "01.27.2005", I want to format as "JAN.2005" (not "Jan.2005") - is this possible?

How to take data from one spreadsheet and copy it to another. The porblem is I have to scan columns on both for a match first. The only example I could think...