software

I am trying to determine the appropriate equation for my application

I have two spreadsheets with different data which I am subtotaling the same
way; a count of the number of entries in a certain column at each change in

If I import a long series of values in a column, how can I reverse the

Need to combine 100 email addesses in separate rows (in Excel) into one cell,
separated by comma, so I can do mass mail. Formula I'm trying won't work.

I have a worksheet 18 columns by 16 rows. I want to delete only
the numbers in a specific column. I don't want to lose my formulas.

I'm having a strange problem with a chart done in Excel 2003 (on a workbook
prepared by someone other than myself, so I'm not sure of all that has

I have a sheet of 10K rows that have entries like this: 000345, 0034567,
0000067 etc. I am trying to do a vlookup on another table of 10K rows and

I work in a library and want to sort lists of CD titles. I want to sort the
list alphabetically while ignoring articles (e.g., the, a, an) when they

Every time I use VLOOKUP on a certain PC it asks what path to take. The path
is in the VLOOKUP so it shouldn't ask. To select the path in every cell is

I am using the Smart Tag feature for updating stock quotes. I selected the
Remove this Smart Tag to remove a Financial Symbol from one worksheet, and

I want to be able to set up graphs which will update automatically once
differed filters are applied using autofilter. Can this be done?

Is there a way to Sort a Spreadsheet by Color? I have an enormous spreadsheet
with yellow highlights scattered through and I want to sort by the

I have approx 6 spreadsheets I need to merge into one document to receive a
final result. Each spreadsheet will be worked by a different indiviudual.

i'm trying to enter a formula for an invoice in excell h.s.landing @ 3.80 a
sq mtr x 10sq mtrs would be £38.00. how do i write that as a formula so that

I now have all of my info on one line. I can get it to sort.

I have a spreadsheet that looks as follows:
A B

D7 has a dropdown list with customer names (10 -12 customers). F16 thru F38
each have a dropdown list with a vlookup of a products list. Infomation in

Looks like this;

I want to be able to automatically copy data from a number of different
spreadsheets to a summary spreadsheet on a weekly basis using the VLOOKUP

For ex: if the Value in the Cell is quot;3456quot; i want to change that to quot;23456quot;.
Similarly every cell should be prefixed with quot;2quot;