I'm having trouble extracting data up on a cell up to a certain
character, for example up to "/"
for example this cell data: David Staton / 102 oak st
I just need "David Station" and leave "/ 102 oak" st alone

hello, I am working on an extremely important excel 2002 worksheet and am
using only 3 cells. The remaining cells are locked so they cannot be modified
by any third party. Lets say I am inputing data only in cells D8, M7 and M9.
I always start inputing data at M7, then M9 and ...

I have a 10,000 record list in Excel.
I want to separate the list by odd and even rows. How can I do that?
Thank you,
Gabriela

I Have A Large List Of Customers And I Exported A Report Into Excel
That Has Their First And Last Name In One Column And Their Street
Address Only In The Second Column.
With 6000 Customers On My List, I Have Something Like 125-130 Pages Of

I've seen this answered somewhere before but can't seem to find it now.
I'm looking for some VBA coding to check is a subfolder exists on a preset
path and create it if it doesn't.
I have created code to get files and report errors if they're not there so I

Is it possible for a function in a cell or a macro driven line to look
at a cell and change the target cell from this reference cell to 1
decimal place more than the reference?
IE

I need a formual that will give me a reult when I enter in the date and
hour.  For instance if I enter date=3 in cell A1 and hour=7 in cell A2, I
would like a formula in cell A3 to return a value of 56.  Is this possible?
Thanks for any help.

I have a workbook which has quite a few worksheets.  I'd like to have a table
of contents which lists each worksheet but does not necessarily have to link
to said worksheet.  How might I accomplish this task?
Thanks in advance for your assistance!

I have 8 Pivot tables in a spreadsheet containing identical data with months in columns, account numbers in rows.. These Pivot tables represent the monthly expenses for 8 departments.I have created a standard Report in the same spreadsheet, to view the data with percentages and ...

I'm looking for an answer to something that has thrown me for a loop.
Is this even possible?  I need to take the values from 2 colums on one
workbook and paste them into 1 colum on a seperate workbook so that it
appears [m: "firstcolumvalue" mc: "secondcolumvalue"]. This is due to

I want to calculate a rolling annual sum of numerical data based on
corresponding date column.

I am trying to figure out how I can use the SEARCH function when it does
not find what it is looking for and returns an error.
I want to make an if statement that does one thing when the search
finds a string, and another if it does now.  But if it does not find

I have a formula in a cell (destination) that derives a text field from
another Excel Sheet (Source).  When I enter new text in the Source sheet, as
expected it populates in teh destination dield. However, the destination
field needs to be adjusted to display the entire contents ...

Assume two columns. I want to perform an operation on a cell in the first
column and then repeat that operation on the cell below as long as there is
at least one character in the second column. When the second column is blank
the operation stops. I set up a macro to perform the ...

At issue is some numbers are 7 digits and some 8 (ie 7012006 or 10012006).  
None of my attempts resulted in excel recognizing as valid dates.