How do I flip the order of the content in a cell.  i.e if the cell reads
Michael Smith how do I get it to flip to Smith Michael without having to
retype.

I'm wanting the email a spreadsheet with my color changes.  I've tried
inserting them into the sheet code but that won't allow any macros to
function.
Help please,

Have downloaded data with first and last names lumped together in one cell.
Is there a way to have excel split the first and last name into two separate
cells?

How can I use the percentrank function on non-contiguous cells? Thanks in
advance as always.

Hi, I hope someone can help me
I have the following formula and as I step through it, I can't see any
problem with it, however it keeps returning an error.
Rolls!A4 contains the following formula

I have a spreadsheet as follows:
Column A          Column B        Column C        Column D
04/09/2007    Ann Other                14/09/2007    04/10/2007
04/09/2007    Joe Bloggs               

Ive been looking all over for a solution for this.
I basically want to count the amount of times a date falls between 2 dates.
The problem is that my start & end date are in different columns of a row and
I have 100's of Rows that have the start and end date

Hi, I like to convert 4,30 to 4,5, I type in 4,30(4m & 30s) and I want to get
out a dec. of 4,5. This is because it should be easy to type in the data? Is
it pssible?

I am trying to add the values of two cells which contain links to other
worksheets.  Can I do that and how?  (Ex.:  Cell C6 equation =SUM(C16+C42).  
Cell C16 is linked to Cell f46 of worksheet 6th while Cell C42 is linked to
Cell F46 of worksheet 8th.  A "value" does not appear ...

G'day All,
Is it possible to use variables in formulas without storing them in a cell?
i.e. (a simplified example)
VarA=SUMIF(A:A,Y:Y,X:X)

I'm trying to work out how to increase the length of a dop down list within
an excell 2003 worksheet, or in other words how do I get the drop down list
to display more data (approx 30 options) without having to scroll through
those options within the drop down menu.

I've created a daily input worksheet and it kicks out the results to a pivot
table.  I want to create a button on that chart for the user to click on so
it can refresh data.  Doing so just in case they don't have the pivot table
menu open, or forget to click in chart to bring up ...

I followed the directions from the previous post, but this doesn't work. In
the drop down box there is only the worksheet that you copy from and "new
workbook".  The other workbooks I have open are not listed in the drop down
box.  What's the fix for this problem???????

Hi, is there a formula that will record the time and date that an
entry was made on a sheet.  I am trying to make a telephone log that
will show me which customers called for which salesmen, so rather than
entering the time and date against each call entry I wondered if

Dear all,
just want to know is it possible to autometically put a double quotation
mark in the cell content within the same column? because there are 84 cells,
i don't want to do it manually...