I have a roster with several thousand names in a .doc file. It is organized by Last Name first, followed by a variable-length string of spaces, then by First...

You need to have a condition of FormulaIs, and a formula of =NOT(ISERROR(FIND("ball",A1)0)). Just set the pattern colour and you are away. -- HTH Bob...

I need a bit of assistance with this one. Can someone modify these functions to accomodate "", NULL or 0 so not to have the #N/A error? 1.)...

Is it possible to send a "form" email to all contacts from an excel database? Answer soon if you could to . Thank you! Marcia

Hi Michael one...

Excel reads a number such as 10-10-7001 as a date. How do I turn off 'auto number formatting' so that if I enter "10- 10-7001" it comes off on a report as...

Using an excel form to add new records, what is the best way to then add this data to an existing table within the same workbook. Thankyou for your help Cerys

Anyone know where I can find this add-in?

Tom you have been a lot of help. I have been checking out the functions command - Index and Match vs. VLookup. I am beginning to understand you answer....

One easy way to add data to an existing table is to use Excel's Data Form. To use it, select a cell in the table, and choose DataForm. Another option is to...

Hi, I have two questions as below: 1. In Office 2003, how do I have the Microsoft Excel Help dialog shows up with contents tab and index tab? 2. Is this is...

How can I conditional format, so that if the day hasn't passed, the colour of the cell is Orange, if the day has passed it is Red, and if the day is today it...

Hi Alan! When the time is copied and pasted it will be formatted as text: 02/07/2004 14:00:00 ES You can strip out the time...

Hi, I need a formula to calculate the date of the last monday, tuesday, wednesday, thursday or friday of a given month. Can't seem to find the answer...

Robert Putting a negative qty or negative amount is one way. Another way is to change the SUM line where the Subtotal is. If the value you want to take off is...

I have seen the VB code that will count cells with a specific color. I have seen the VB code that will set the font color of all characters in a cell. What is...

Thanks Frank - your solution works a dream Steven. -----Original Message----- Hi Steven try the following custom format 0.???? use as many '?' as you...

I want to impose two conditions. Specifically, If G8=100 and H8=, value if true,value if false. I am failing to find the proper syntax. Any help would be...

Would anyone know how to refer to a string inside the formula property value? In my case I am checking a named cell to see if it is holding a specified string...

panjas wrote: When I insert a comment on a selected cell, the default font for this comment is Bold size 8. I whish to change this default font for...