Certainly there is a simple way to find out if a cell that has text in
it contains a certain word.  For example, cell A1 is populated with
the words "Houston, TX, USA."   In Cell A2 I want a function that can
look into A1 to see if the word "Houston" is contained in there.  If

(Kinda long explanation here to make people understand what I want t
know, just *read the summary if you don't want to read everything her
for topics I need help with*)
All right, so I haven't used Excel in years so there are some things

Can we make a vlookup when lastname may have slightly differnt spelling in
middle characters?

I have a spreadsheet with 4 columns.  I am scanning some bar codes
into the 2nd and the 3rd column.  I want to the active cell to change
to the 3rd cell after I scan the bar code for the second column.  This
is obviously easy to do.  But I want it go to the 2nd column of the

I have a list of names. Is there any way to count the unique names in
a corresponding row, and if a name repeats, list the same number it
had before?
Names      #

Hello, I have a summary sheet which links to many (20ish) password protected
files. Every time I open it or update the links, I have to enter many
(20ish) passwords.
Is there a way I can avoid or automate this process.

I'm using Excel 2003.
Does Excel allow me to change the fill-color of a cell based upon the
contents of that cell?
For example: If the formula of a cell calculates its value to be less then,

I'm currently downloading SP1 for the Microsoft Office Suite 2007.
Does anyone know if this addresses the issues of Excel
2007--slowness--hangups, etc.

Is there a way to make a conditional custom number format?  I have two
formats that ALMOST work for what I need, but not quite.  #.# works for most
numbers, but if there is no decimal in the number it displays an unnecessary
decimal.  ## works for most numbers EXCEPT for ones ...

I have a Summary Workbook and it gets information from other workbooks
Whenever I open it it will not update - it has an entry of 0 - I have to go
through the tedious task of doing it manually
This is what is in the Cell

How to convert hours using 00:00 format into standalone numbers, for
example 08:30 = 8.5h so I could sum these numbers at the bottom to
learn how many hours are in total.. Please help

Wrap text is not working in the cells in my tables.  I right click on any
cell > Click on Table Properties > Select the Cells Tab > Select Options and
I ensure that "Wrap Text" is checked.  However, text is not wrapping.  Please
assist.  Thanks!--

I have the following problem. We're sealling 2 products, each has
different payment term and the payment term can change during the
year. It is pretty simple if payment term is an equivalent of 30 days
(if =30 then inflows are in the next month, if =90 then inflows are in

I have a bunch of rows that yield results in the last column that in
many cases are blank or zero. I would like to be able to view the
results of only those cells that are non-blank, and show them on
another worksheet page. Copying the whole column would of course keep

Hi, I have a list of URLs and I would like to find a way to extract
the domain name from the URL.
The URLs can be prefixed with www in some cases and I'd also like to
strip that off.