General

Cut and paste specific data
`Hi Have been working on a problem which I think I can now simplify Cell A1 contains the following: 15 Smith Street Blacktown How can I cut the last item (Suburb) from the cell and paste it into B1? Many thanks in advance Stephen ... 19 Apr 2010 18:50

How do I create a feedback form?
I need to send out a simple feedback form to attendees (130) of a forum I held. Not sure how to do a simple feedback form with about 5-6 questions? ... 19 Apr 2010 18:50

Protection
I know its basic but how do i protect a sheet so that when i delete an entry i dont delete the formula? Thanks James ... 19 Apr 2010 17:48

need a formula to find "*" in s string and multiply by preceding and following values
I have cells enrties which can look like this: Cell Entries: >> Desired Results Cars 6 6 Trucks 11 11 Bikes 4*3 ... 19 Apr 2010 18:50

Number format changes to date by itself
I opened a spreadsheet saved earlier in the day. Nearly all of the cells containing numbers that had been formatted as "number" changed to a custom date format of Jan-00 or similar. What's up with that? This was in Excel 2007 ... 19 Apr 2010 16:46

Excel 2007: @*. formatting
Is there any way to make this format work with Wrap Text turned on? Whenever the text is wide enough to need to be wrapped, I always get #######################. ... 21 Apr 2010 20:53

TimeStamp
I currently have a spreadsheet set up that employees use to timestamp their login, logout, lunch, etc. I have a button on the spreadsheet and a user chooses a cell and clicks the button for a timestamp. There is one problem I'm running into. A clever person could change their system time before they click ... 19 Apr 2010 17:48

Automatic Pareto data with Formula
I want to create a data table for use to create an Automatically updated Pareto Chart, for this I need that the values automatically be sorted in descending order, so I have the following example scenario: Column A has Labels and Column B has Values A -1 B -2 C - 3 D - 2 E -1 If I use the following form... 19 Apr 2010 21:56

Column link
This is great! Ok Next question: I need to link every cell in column e worksheet 1 with every cell in column j worksheet 2. Its for closing balance in Jan, and opening balance in Feb. Thanks all James ... 19 Apr 2010 17:48

Date Format not working
I have a column of dates that are formatted like: 04/19/2009. BUT I want them formatted as: April, 2009 I cright click and try to format the date but nothing happens? Why? How can I change the format of these dates? I am using Excel 07 ... 20 Apr 2010 07:15