I want to change telephone numbers from format (XXX) XXX-XXXX to 1-XXX-XXX-XXXX. I also want to add 1-XXX to XXX-XXXX in cells.

Hey Everyone, I'm trying to get a linear regression function to work and am having a lot of difficulty. I need the function to do a linear...

I've got a long list of text data in column A, and am using the MID command to extract one bit of data from each which is then inserted into four columns...

Hi, I have the following sample data I have data identifing (1) the description of a document issued (column ranged named SI_DES) and (2) the date it was...

I need some help.... If i have a worksheet and i want to pick out anything in column N that has a value of "TR" and then return the value of the data that is...

I was browsing for help on this subject and figured someone might be able to help me here. I have an existing excel spreadsheet that was formed from a...

I have a spreadsheet that creates a quote to a client for the install of equipment in their rooms. On sheet one I enter the piece of kits model number and...

Hi all, I've had no luck with a formula to calculate profit and loss based on a strategy in the market all the time either long or short. Column A is market...

Could someone point me in the right direction with a formula. I am trying to use excel to backtest some trading rules and one column designates a long...

Hello Group Excel, I am using Excel 2003. My computation Columns are "E" to "J", and starts on Row 15. Column "I" is the Total. Column "J" is the Running...

I have an extensive worksheet that has many conditions. I am using Excel 2003. I did not see this article as it relates to my issue, but, I am wondering if...

To whom it may concern, et al: As I enter data in a cell, at the same time I want it to show in another cell. The information can be either numeric...

Some of my cells are turning up the value "#VALUE!" in the cells. I have duplicated the problem that I am having. A test worksheet. I am using data in one...

Working in Excel, I am looking for help using fill-in boxes. I am creating a form. Setting up a cell or a bunch of cells merged where you can enter a...

Hello Group Excel, I am using Excel 2003. My computation Columns are "E" to "J". Column "I" is the Total. Column "J" is the Running Total.

Working in Excel, I am looking for help using interactive fill-in check boxes. I am creating a form. Setting up a cell or a bunch of cells merged, or not...

Is there a way when I protect a sheet to allow the TAB key to work so that I can tab through cells? -- You want it done by when? *laughs*

I would like to fill data (of cell A1 - for example) into the entire column below it (cell A2 until the end---in excel 2002 until cell A65536; in excel 2007...

I would like to fill data (of cell A1 - for example) into the entire column below it (cell A2 until the end---in excel 2002 untill cell A65536; in excel 2007...

In previous versions of Excel (through 2003), you could set up a sort on one range of a worksheet and then use it on a another similarly set up range in the...