I have a database of over 1,700 line in which more than half have addresses in ALL upper case. I need an easy way to change MAIN STREET to Main Street...

Hello, In A1 I will have one of the following number: 0, 1, or 2, which represents the number of clients lost. In cell B1 I have the text "0 Clients...

I have an Excel model that after I moved it from 2003 to 2007 has a lot of redundant conditional formatting rules. Some conditional formats moved fine,...

I have a user, who, when in Excel 2007, needs to click on some buttons twice to make them work. This is not a "double-click" as we are used to. For instance,...

I have thousands of cells in a report with information that I need to separate into different cells. Ex. one cell: Arch | South | All Points | ...

I need help updating a single cell formula. G4 has a formula of *=12500-A7 I would like to update this so that A7, A8, A9 are added together then subtracted...

I am trying to create a pivot table to show marketshare percentages, essentially I need to show the number of transactions in a pivot table as a percentage...

I posted this prior with no final answer to my question. I'm looking for a formula that can help sort calendar from fiscal year. I'm hoping this is enough...

How do I reactivate "Save On Exit" in Excel 2007? It seems to have been turned off somehow. Thanks, Tom

I have a huge database in excel. Unfortunately, some of the entries are in ALL CAPS (E. MAIN ST or JOHN SMITH) It is unfortunate as they need to be E. Main...

I have a one page Excel file that when I use Print Preview it cliams that there are 19 pages. Is there a way to fix this? Thanks for your time. --...

The menu on my Excell sheets is on aito-hide. How can I turned this off?

Good day, Until a week ago, I could use alt + enter to create a line break within a cell in Excel 2007. I am no longer able to do so. When I depress the...

How do I create a normal read only Excel file in 2007? I’ve recently received a .xlsx file which is read only and I would like to be able to do this...

In Sheet 1 I have a certain amount of data, I want to select some cells and copy them to Sheet 2 keeping the same format. When I do this, the fonts and the...

Working on a word document with the links attached from Excel - Everytime I open or save the file, getting this error in Excel 2003 and drives me crazy - The...

I'm having a different computer and need to transfer my customisations over to it. I know how to transfer my macros & toolbars but can't work out how to...

Is it possible to create an event after a save? I have a macro that runs before a save to hide specific sheets and would like those sheets available after...

I have an Excel workbook that resides on a network drive for many users to access with links to another workbook. I wanted to turn off the "Update Links?"...

I've scanned through related posts with no luck. I have a production spreadsheet with several columns of data. Here are the relevant columns (3) for my...