Functions

Acronym Function?
Is there anyway to generate an acronym on cell contents with a function? Ideally I could ignore certain words e.g. of, the, and, etc. and then for the first letter of each word generate an acronym e.g. United States of America = USA ... 11 Mar 2010 16:53

formulas
how do i write a formula to add cell contents that are seperated by ten other cells? ... 11 Mar 2010 16:53

The Tueday prior to a holiday...
If I have holidays identified with an H in the A column, I need to find the prior Tues, from the Sat prior to the holiday. Basically I need to find the Sat prior to the holiday, then go back 4 days. I'd like the results to show in the D column like ALERT. Thanks, Steve A B C ... 11 Mar 2010 15:44

Sum Multiple Worksheets, same named cell
I have multiple worksheets containing the same named cell (e.g. Month_Total). On a totals worksheet, I am not able to use =SUM('START,END'!Month_Total) because of the local/global naming. Is there a way around this? (Month_Total will not always be in the same cell on each worksheet). Thanks! ... 11 Mar 2010 23:35

Running Sum
How do I calculate a running total for specific functions? My example is as follows A B C D E F 1 Function: Email Phone Email Faxing Prepping 2 Start Time: 4:25 PM 6:15 AM 6:30 AM 7:05 AM 7:50 AM 3... 11 Mar 2010 14:36

Macro question
I need a macro that will add the text -0000 at the end of whatever text is in that current cell. For example Cell = 75154 I need to add -0000 at the end of this so then it will be 75154-0000 I have tried all the formating stuff, but the Zipcode cell format doesnt work. ... 15 Mar 2010 00:17

Merging different sheets
hello everybody, I have to work with 2 sheets. In the 1st one my data are arranged as follows: Payment Date Type 15/02/2010 XS 15/02/2010 LS 16/02/2010 XS .... ... and in the 2nd sheet: Task Activity XS Activity1 XS Activity2 XS Activity3 LS Activity4 LS Activity5 .... ... 14 Mar 2010 03:19

left/right or center ?
I have days off in the P column in this format: Sat/Sun I'm using them in another column in this format SatSun, so I'm using this formula: =LEFT(P21,3)&RIGHT(P21,3), which produces SatSun However, I have some days off that just have Sun, which produces SunSun. How can the formula be writen to produce SatSun when... 15 Mar 2010 13:30

create a button to print certain tabs in excel 2003
I would like a way to search every tab in 1 workbook and the same cell on each tab, than based an the value in the cell print the page or not ... 11 Mar 2010 16:53

Multiply Cell Values which include text units
I have a formula in cell G13 that shows "=B13*C13". Is there a way that i can multiply cell B13 which has a number format and reads "61 Units" to cell C13 which has a currency format and contains "34.23 / Ea" to get a value of $2,088.03 shown in cell G13? I don't know if I can show text in the cell that is be... 11 Mar 2010 13:28