Imagine that i have from a1:a1000 cells with email adress.
I want get all domains in that cells.
supose in A1: teste@tes.com A2: teste@pl.com A3: dfdsf@kon.org
I want one formula that could me give all information after the "@". lik

This might be a silly question, but I haven't been able to find the
answer.  I have one cell that will always have the the following
format: ABCD1111111111111111 (4 letters and 16 numbers).  That will be
my first cell, I want to be able to create that number plus 1 on the

I am trying to figure out a formula using today date - start date=
years.months in service.  Can someone help me.
Thanks.

Hi
Ok i am not sure how to go about this but i have a pricelist which i
set at A4 size.
I need to be able to print the document so it forms a booklet.

I have to change a great amout of formulae from a simple
=A3/A4  to either
=ROUND(A3/A4,0)   or
=IF(A4=0,"",A3/A4)

Hi again everyone,
I have a graph that has 5 variables in a stacked column.  X axis is
year, Y axis is total number of people.  On the same graph, I'd like to
label each individual series with its % of the total for that year.

I'm rather new to Excel and a colleague who is no longer with us created a
workbook.  In one of the columns of the workbook there is the same
instruction note in each cell.  This is not a comment as there is no red
marker and when I try to delete comment it's still there.  The ...

We run Excel off of our local desktops, but same most of the work to a
server.  We frequently get error messages when we attempt to save a file.
The save process just stops mid way through and says, document not saved.
This doesn't happen with any other programs like MS Word.  Does ...

I cannot view my Excel documents because it says Restricted Access. I dont
need restricted access on my own document. I therefore cannot format my
document. How do I remove this? I have even signed up

I have a file that i do not know how many sheet are there in before
i need to copy contain of C4 to name of sheets
Thank for your help.

I want to use multiple ranges (named) as the data source for a pivot table
using MS Query.  When I import the workbook my options are only to select the
"tables" (which are my sheets referenced as sheetname$).  I don't want to use
the entire sheet, just my named ranges in ...

I recently created a workbook with lots of tabs,data etc. I noticed that
the size of the file seemed huge in comparison to a file with similar
content (30Mb / 1Mb), but couldn't see why.
I found that if I copied a single from the file tab to a new workbook,

In latter versions of XL the highlighting of selected row and columns
is nice and clear.
However in XL 97 exels just highlights (or drops shadow) the column
letter and row number a little bit.

I have a problem.  I would like to update some old ID with new ID and
new names.
I have 3 columns at the moment, Say ColA is the old ID numbers, Col C
is new ID numbers and Col B are names of the new ID numbers

How do I edit the "right click menu" in Excel 2007 Beta 2?