How to split cell based on capitalised suburb name3300 (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 computer0141 (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 month11049 (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.?
PowerPivot Beta0184 (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
Why is this formula returning "#Name?"?0197 (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
Down Arrow problems2200 (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
Excel Help Please quick question7143 (11/15/2009 2:13:01 PM) i want to have a cell automatically fill its self in when another cell says a
eg - if i type "blue" into D5 i want D6 to automatically change to "yes"
Is this possible