I have a minor Excel formula problem.  
In my example has following data, cell A5 shows "apple", A6 shows "salt", A7
shows "sugar" and A8 shows "fish".  On another hand, cell B3 is the
"criteria" data showing 3.  

Re : Excel Wrap-Text with Relatively Loose Strings
1. Enters an Excel worksheet (received from the wilderness).
2. In a fixed-width cell, there is an entry such as the following
string :-

I have a date m/d/yyyy and would like to convert it to mm/dd/yyyy.  I tried
format-custom-mm/dd/yy but it is returning m/d/yyyy can someone help me out?

I'm trying to teach myself Excel XP (using "...for Dummies").  I used
Autofill to create a daily time schedule column, but in alternating cells
(e.g., 6:00 AM/[empty cell/6:30 AM/[empty cell]. Is this an Autocomplete or
Autofill function? Also, it uses military time. How do I get ...

Being a complete newbie here, my question is as follows.
I have created a spreadsheet for our Little League baseball team by position
and inning. In each cell I have created a dropdown menu that lists each of
our 11 players by name so that all I have to do is select the players ...

I want to create a Excel workbook that will help in specific poker
situations.
Short version: I want to be able to calculate how often my opponent will
need to fold for an all-in raise to show a positive expectation.

Here is a tough one:
I have a table with rows of information including an ID Code. The ID code is
made up of four characters, each meaning something distinct. I want to
create a flexible reporting system where the user can specify which of these

I had no problems with MS Excel 2007 so far, and yesterdays my
files saved OK, but today I found Excel can't open neither of my many
spreadsheets
created before. It crashes and attempts to send a report to MS.

We use Office 2003 standard on Windows XP computers.  All the computers are
P4 2GHz machines with 1GB RAM.  I have one user who has a problem with
running Excel and Power Point at the same time.  She can never demonstrate
to the problem to me but says that they simply shutdown.  ...

I need to set up a spreadsheet for a business and do not know how to go about
it. Does anyone have any assistance they can offer?

I need help with this and hopefully someone can assist! I am working with a
spreadsheet that has different start and finish dates during the fiscal year
(Oct - Sept). There are man hours associated with each person and their
availability. HOW CAN I FORMULATE TO SHOW THE # OF ...

Hi there,
I use this site quite a lot, but its more luck than judgement that I ever
see any of the replies I am sent.
I get sent an e-mail with a link to the replies that doesn't work, I search

I wish to type in the cells 0100, 0200, 0300 etc  but cannot see the format
type that retains these numbers as four digits (allows me to go to 2400) .
Which format is it - I have tried several and it drops the first zero(0) off.
Cheers

I cant get the condA or condB to execute if value of A1 fall within range 1
to 10
if(and(A1 >= 1, A1 <= 10), condA, condB)
How to get the month with a increment value as below

Hello - Anyone familiar with a way to take an average of a range of
cells, but only for the cells that contain values.
So for example:
9