Hello, I need a query that will left trim everything after the first comma in
a string.
Example
1 Airport Boulevard, Gentry, AR 72734

Hi all
I want to understand the logic of array formulas that how they work. infact
I want to know the crieteria behind making the arrays.
I used some arrays and made some as well (like SUM IF array) but the main

I have 30,000+ rows of order lines (extract from database). I have a report
setup that takes four criteria (retailer chain, order type, product group,
and brand) based on validation in B1:B4 from this I use an array formula with
SUMPRODUCT and four IF's (used since the criteria ...

I am pretty new at using the excel spreadsheet and need help setting
up a formula.  I am setting up a drivers log and the formula I'm
trying to get is this
If G28+G29 >=34 then 70 is the output numer, if G28+G29 <34 then the

I copied and pasted into excel the data that has rows and columns from web
page display in IE6. In excel I tried to sort by a column and I am getting
the display that says, "This operation requires the merged cells to be
identically sized." I noticed that I cannot expand a column ...

How can I restore a deleted worksheet in Excel?  When I restore my computer
back a day it saves the worksheet without what I deleted.

Using one of the two formulas below to display the name (in column B) of the
highest scorer (from column C) in another cell (B*)
is it possible to modify either to display the highest four placings?
How would I allow for a tied score.

My spreadsheet has several columns.  Two of which are:  Phase & Account Name.
Account Name is in Alphabetical Order, and each account has a Phase assigned
to it.  (1,2,3,4,5,etc).    I am using Auto-Filter to view each phase
seperately.  

I have a small problem , which I hope someone can help with.
I have a sheet with a variable amount of rows. In column P:P I want to
replace blanks cells with the word NULL.
I highlight P:P and press F5 to bring up the Go To dialog. I press

Hi...
This is the example I have in a spreadsheet:
Cell A2 = 100
Cell B2 = 11/30/10

I have inherited a complex spreadsheet with formulas all over the
place.  The requirements are long gone.  The original developers used
named fields to define cells referenced in the formulas.  It's easy
enough to display all the formulas in one or all worksheets using the

how to send excel 97 workbook as wallpaper

A user has 4 separate files with the 4th file being a summary file; Alloc1,
Alloc2, Alloc3 and Summary files.  The Alloc files have numbers in the same
corresponding cells she wants to add together to get the summary numbers.  
What she wants to do is use a formula to sum the ...

Excel 2003 SR2
I am combining several worksheets into one.  I'm doing this 5 times for 5
alphabetic ranges.  Some times I need to combine 4 worksheets, or 5 or 6,
depending if worksheet 5 or 6 have data (if 5 doesn't, 6 will be blank, also).

I have a worksheet with a date column alongside a column with
irregular entries. Some dates have no data alongside.
How do I reference the last cell with data in it?
I hope I have made myself clear!