How to split cell based on capitalised suburb name 3 300 (11/16/2009 6:09:01 AM)
Hi I have data such as the following in a single cell per line Level 8, 160 Marsden St, PARRAMATTA 15 Carter Street, HOMEBUSH BAY 223 - 239 Liverpool Road, ASHFIELD I want to put the Suburb name int...
Utf

Not able to see all data but can see on another computer 0 141 (11/16/2009 5:06:01 AM)
Hi, I am using SAP application and if i retrive the excel file from SAP i can see only 48 lines where as i should see 110 lines but if i opened that same excel file in another computer then i can see all...
Utf

Increase cell value by 1 month 1 1049 (11/16/2009 3:48:01 AM)
What formula do I use to increase cells by 1 month? i.e. If I have December 2009 in A1, how do I get Jan 2010, Feb 2010, etc. in A2, A3, etc.? ...
Utf

PowerPivot Beta 0 184 (11/16/2009 4:31:02 AM)
If you have not seen PowerPivot you might want to check it out. It's the collaboration between the Excel and SQL teams in Office 2010. If you use Pivots today, you will love what PowerPivot can do for you....
Utf

How can collect data from multiple sheets in the same workbook? 2 424 (11/15/2009 11:34:01 PM)
Hello, I am trying to collect data from multiple sheet in a workbook. I want to summarize the data on a seperate for printing. ...
Utf

Why is this formula returning "#Name?"? 0 197 (11/16/2009 1:11:31 AM)
Hi, I'm using the attached formula across 30+ rows on a number of worksheets in a number of workbooks. On every worksheet the formula returns #Name? in Row 17, but returns the correct value everywhere els...
RPS

Down Arrow problems 2 200 (11/15/2009 12:04:01 AM)
I am using Excel 2007 and whenever I press my down arrow on the keyboard it moves down one cell and over one cell to the right. I am trying to figure out what setting has made it this way. Does anyone k...
Utf

Selecting "Save As" adds "Copy of" to file name- MS Excel 2007 1 578 (11/15/2009 8:59:01 PM)
I would like to stop the extra wording added to the file name Ron Hansen ...
Utf

How do I stop a letter c in parentheses becoming a "copyright sig. 3 885 (11/15/2009 4:57:01 PM)
When typing (c) in Excel it converts to a copyright sign - a c in a circle. How should I avoid this. ...
Utf

Excel Help Please quick question 7 143 (11/15/2009 2:13:01 PM)
i want to have a cell automatically fill its self in when another cell says a certain thing. eg - if i type "blue" into D5 i want D6 to automatically change to "yes" Is this possible Thanks ...
Utf