Hello All I look to see if I could find something on this but didn't get
quite what I needed.  I have a user who wants to add some columns up but
there are only alpha characters in the columns
for example

Can you let me have the function for finding the last space in a string?
At the same time, for future ref the #th space in a string please.
My present problem is to separate the number at the end of a series of
strings, typically:

Is there a way to not show decimal figures depending on what that
decimal is?
For example.
I will have only the following in cells

Is there a way to format an Excel date such that
 -  the day of the week appears as a single letter? SMTWTFS
or
 -  the month appears as a single letter? JFMAMJJASOND

I have to search and put values in one of my sheets after looking in
a
field of a field. I believe i need to to a nested vlookup, but im not
sure how to go about it. I copied the relevant portions of the data

Hey there all -
I am sure that this is terribly simple, but it has eluded me thus far.  I am
trying to figure out how to find the first blank cell in a range.  I am
working on creating a time sheet, and I need to be able to find the first

I have a long list where I want to hide the rows when cell B(row) = #NA
I dont want to use Autofilter, is there a function or maco to hide these rows
Thank you very much in advance

I have a document with multiple calculations in it and for some reason today,
one of the tabs that has calculations is showing only the actual calculation
and not the result.  The formatting is just not working.  I even have a
column that is set up with a "date" format and ...

I am trying to make a formula that gives me the lowest price at a named cell.
eg. E7,L7,S7,Z7 are different prices, I want the lowest price to be at AD.
The other issue I have is that each one represents a different colour.
eg. E7 -green, L7 -purple, S7 -orange, Z7 -pink.  

New job and new laptop running Office 2003. Very expereienced Excel user.
However, using Excel on 3 different computers are giving issues in particular
with copying formulas. I want to click on cell and drag to next column over.
Data is different in both columns, formula copies ...

High guys, bit new to this Excel malarky so any help would be fantastic.
I am tring to set a score prediction leauge for our office.
What I would like to do is this
IF D3 & D4 (Home and away team prediction) MATCH C3 & C4 (Home and Away Team

I am stuck using IF AND Function
The amount commission is payable on is due to certain conditions, if a
deposit has been received, if invoice has been paid in full, if full payment
received within 21 days.

I am confused as to why I'm getting a "FALSE" from 3 IF Statements.  Here is
my function:
=IF(Combo_4_000664!C11="All","1",IF(Combo_4_000664!C11="quota","0",IF(Combo_4_000664!C11="222","1")))
but I am getting a "FALSE" when I enter 222 in my linked spreadsheet. I

If I have a certain cell with text in it that I am hard coding as Female or
Male, and I want the next cell down to automatically state the opposite sex
than that cell, what logical function would I use?
Thanks,

I Need your help in the following:
Column A has "Brands' List", Column B has "Products' List" for each
brand, and Column C has "Country of Origin" for each Brand.
I need to count how many brand in each country of origin!