Excel experts, how would I strip out the dash and space from this phone number, using a formula: (201) 256-2241 so that it looks like this: (201)2562241

Hello Everyone I’m having a issue with a Windows 2003 Environment and Microsoft Office Excel files. We have a few excel file then when edited create the...

i have an equipment list which has everything from vehicle numbers to engine horsepower. there is 38 total pieces of equipment that i need to make individual...

Is there a way I can reverse first and last names in Excel when the first and last name is within one cell? When my software exports it last name, first name...

So, I just upgrade my OS to Windows 7. I have a spreadsheet that does time calculations from time to hours. It has worked flawlessly for years, and even...

When I open an existing spreadsheet it loads and the screen is all blue and I can not see the spreadsheet.

I have an older doc (xls format) that offers me the message "nameof doc.xls should be opened as read-only unless you need to save changes to it. Open as...

For example: I want column A to read "5 gal" and column B read "$25.00" and column C=A/B. But when I enter that formula it won't compute beause in column A...

my cursor in excel is locked somehow and whenever i move the cursor it highlights the cells. i can't click anything, i have tried multilple things. I would...

Hi, I’m new to the site and also to Visual Basic. I have found the following code from Dave Peterson on http://www.contextures.com/xlForm03.html, which...

how to click a hyperlink in excel without using the mouse?

I am trying to calculate within a pivot table that has consolidated multiple worksheets. I need to add two item fields together and then divide the answer...

When I am left or right clicking a cell in Excel, it selects 3-4 cells in lieu of the one I want. How do I fix this? I use a Logitech LX& Cordless mouse and...

Each time I put a number into A1 and I then goto A2 I can know longer see what is in A1 as it moves the sheet over. I like the sheet to not move so I can...

Working in Office 2007 Excel and need to enter a range of numbers in individual cells (e.g. 81-100, 72-80, 63-71 etc.). One of the 'ranges' is 11-25, which...

I have four worksheets. The first one has all members of the group. The second one lists all people who have home phones and their phone numbers. List three...

I have a chart of accounts. All accounts have a hyphen separating the main account and sub account. I have a sumproduct formula that returns the sum of all...

Hello, I have a column of data that returns data that looks like this: : CMCKX I need to eleminate the colon and the space with a formula. Can you help?

If I do this: =ADDRESS(4,MATCH(E37,A2:JW2,0)) I get: $L$4 If I do:

I have several workbooks with many tabs in each. In several tabs, I have cells which refers to data on different tabs or even in different workbooks. Often...