I am trying to create a formulae to do the following: postal code: L1T3H-7 should be L1T 3H7 can anyone help me out.

Thanks Greg but that doesn't work - it still prints on 2 pages. "GJones" wrote in...

This is an excerpt from Help on the ERFC function: "... If x is nonnumeric, ERFC returns the #VALUE! error value. If x is negative, ERFC returns the #NUM!...

i was wondering, is it possible to have data be imported into excel sheet 1 automatically sort into different sheets by the information given. i.e: imports...

1. Select your range in column A. 2. Press F5 Special Blanks. 3. Press ctrl-. 4. Select "Entire row". HTH Jason Atlanta, GA -----Original...

How do I access MDURATION and YIELD in Excel 2003

Hi people, does anyone know how to convert, say 3:15pm to 3.25, or 5:45am to 5.75 in Excel. General question is How to represent quarter of hour as...

I need to select a series of values from a spreadsheet based on a text criteria in the same spreadsheet and then calculate the MEDIAN for those values...

Is there a basic formula I could place in cell A1 in Sheet1 that returns the value from Sheet2 but specifically from the ROW I call for in a cell in Sheet2 G1...

Hi everyone! Is anyone familiar with adding soft returns to a concatenate function? I've tried everything, but it just doesn't seem to work. Is there a...

Is there a way that i can put a micro in to open the search fiture in Windows. I have over 6000 items in execl. But if i want to look at an actual docement,...

In my spreadsheet I have a Range A5:A10 which includes: MLC/ 4169 Hburg CC's MLC/ 4172 NMainCC's MLC/ 4125 BlueR CC's MLC/ 4128 BBurgCC's MLC/ 4130 Frk...

Try something like: =SUMPRODUCT((A1:A100=5)*(B1:B100=1)) Adjust range to suit (but both ranges must be...

HI I have hundreds of HTML links, in my excel workbook pointing to a certain HTML document, however I need to change the location and update the links. Is...

Hi, This is URGENT. Problem: In MS Excel, Column A contains values from A to Z and Column B contains value from 1 to 5. Now, I need to count the records that...

I am trying to use conditional formatting to change an entire row if the date in a cell is more than 180 days old. How do I accomplish this?

In Excel 97 how can I average in one column for a given value in another column. Column R has a list of numerical values I want to find the average but only...

I have a conditional sum array formula where as one of the conditions, I am trying to use the EDATE function with arrays as arguments. However, I keep...

I think you've overcomplicated the example, which makes it hard to reproduce; can't you articulate your problem using simply, e.g., =MATCH(JP,iRange,0) and...

Hi Peo, I posted it again in case anyone missed it the first time. I got your formula to work and although it was impressive it is not applicable for the way...