How do i search for something within a text string in a cell which is in a
range of cells.
so if a cell contains the names "jim, bob, tom" what formula can i use to
just search for "bob"

I am working on a Lease vs. Buy analysis, I have these formulas in the file
but I cannot understand how they work, so I cannot validate the results, and
I need to.
Thanks.

How do I use concatenate to assemble a string that includes carrage returns?

i got some cell with the #VALUE! displayed on the cell and can see on
the
worksheet. Then I preview also can see this #VALUE! or even I printed
out

B8 = 10/15/06
J3 = 09/30/07
The formula below computes 13 months, but I need it to calculate 12.5 months.
=(YEAR($J$3)-YEAR(B8))*12+MONTH(B8)-MONTH($J$3)

I am trying to create a sheet with 2 sets of 2 option buttons (they are also
called radio buttons I believe). The problem is that the 4 buttons are
linked to each other. Whenever I select one button, the other 3 buttons are
deselected. I would like to have 2 sets of option ...

I am trying to match some numbers from a column in one spreadsheet to the
numbers from another spreadsheet.  I basically want to match up which numbers
are in both lists.  I also want to bring the information from other columns
with that number.

I would like to see and use the visual basic editor in Office 2007 (BETA)
HELP PLEASE!!

My wife is a dialysis patient at Freeman Hospital, Newcastle, UK and is more
used to the older units than Kgs. I have been trying to find a formular that
would convert Kgs to Stns, pounds and ounces with the result looking like,
61.5kg = 9stn 9lbs 10ozs

I have spent the last week making a quotation package for a friend of
mine in xls, Although it looks great and does the job I can't help
thinking it would look better as a software package or form.
My VBA is not very good and I have seen forms in there and tried to

I'm trying to setup a code to import a .txt file into Excel.  I have the
import code programmed into a button on Sheet 1 that imports the file into
Sheet 2 starting in cell A1, using four columns through D1.
My problem is that when I try to update the .txt file and re-import it, it

I have an autofilter on a column with 300+ rows.
If I filter on that column, how can I reference/extract the contents of
the very first row returned from the filter even when that first row may
have an 'actual' row number of 178 (or whatever)?

i got some cell with the #VALUE! displayed on the cell and can see o
the
worksheet. Then I preview also can see this #VALUE! or even I printe
out

I have done if function with 8 argurement/condition with no problem.Is
there
anyway for me to have more than 8 condition using if function?
here is the example,

Getting #Num1 error for the rate function for 200000-PV -41067-PMT, and
20-years the rate is 20% . Excel is not calculating the rate.  I can use my
financial calculator and get an answer.
Note:  This does work for 15 years.  I tried experimenting with the