Hi, I'm trying to run some code and part of that is to change to a particular drive, directory and folder. Namely: ChDir...

I have two columns of names, they include commas seperating last first etc...how to I do a text comparision function to see if a cell in column 1 is in the...

Hi, I want to create one word file from excel file, eg if in one cell mention txt is Mudit , in other 29..... i want out in .doc format - My Name is Mudit,...

Two questions. Does anyone know how to get into the formula bar to edit a formula without using the mouse. Is there a keyboard shortcut to enter the formula...

Hi, I have a formula as follows: =IF((AND(D5$100,000,E510%)),"yes","no") I want to add another condition as...

Help! Something is weird with my Excel sheet. When I enter a formula, for example =AB2+AB3 Excel does not calculate the result. Instead the formula just...

To give you a feel for what I'm trying to do: I have 1000+ different rows of commission rates. There are 7 criteria which define each rate (criteria in A-G...

Hi, I have 2 columns of data in sheet 1 as follows: B C Open 08/30/05 Closed 08/01/05 Closed 08/30/05 Open 08/03/05 Closed 07/01/05 Closed ...

I am trying to delete cells in a spreadsheet but the option is not available. It will allow me to delete rows or columns but not cells. Any thoughts on this?

I have a range of 8000 cells that contain #VALUE!, I need to find the sum for the cells contained in the range with numbers.

I have a column in Excel with social security numbers and i need to make the formatting so the number has no dashes in it. So for instance 111-11-1111,...

I want to select the entire row and change the color of the row where the word "CASH" is in a single cell. The following code of the macro is not working. ' ...

Hello, I am trying to use hyphens in my worksheet. For example, I would like to enter 6-9 instead of entering 6,7,8,9. But, every time I enter 6-9, it is...

I have a huge spreadsheet where my secretary entries patient names and other important data I am wondering if she inputs a patient name on excel spreadsheet...

I need some help here. At work, I need to use an excel sheet and I realized to my horror (weirdly enough I was the first to notice) that if you opened the...

I have the following data: S12345 S12346 12347 12348 I would like to sort it in ascending numerical order, omitting the leading 'S'. Is there anyway to do...

Hello all, If this is not the correct forum - please re-direct me. I have two Excel files. One file contains information on roughly 10,000 people, including...

Here's my dilema: I have spreasheet full of addresses. I'd like to sort the street address column by street name, however the column includes both the...

Dear Reader, I have got following simple problem that seems to be hard to solve: I have an AS 400 system calculation that adds $ amounts on the condition...

I opened an excel document sent as email attachment. I did not save it to disk. I worked on the document while open as an attachment and saved it. When I...