I hope someone can help me. I have a file containig contact informatio
with all the data in column 1 i.e. name in cell A:1, complete addres
in cell A:2, phone number in cell A:3.
I need the data in a database format i.e. name in A:1, address in B:1

In the attached file,  when a cell (any cells lower than A2) is clicked
a "combo box"(?) pops out to let people to select a item form the list
What is function name, how to make it? Please be ware the A1, A2 don'
have the feature.

How can calculate all the mode values ?
The function *mode* in Excel gives the first value only.
example, values on the column A:
     A

Here's a new one,
I have a spreadsheet that when it is opened it creates a shortcut to itself
in the same directory, there are no macros in the sheet and pretty simple
calculations, I have other spreadsheets in the samw directory that do not

Hello , i am an italian technical
i have this problem:
- i have a server (windows2000) and one file excel
- two users (user A and user B)

I am trying to identify a formula which will add and then display th
number of times a number appears in a range.
For example, the range looks like this
......A...........B............C    

upon creating my first spreadsheet, for inventory purposes..........is there
a way to carry totals from one spreadsheet forward to a new spreadsheet
using the same excel Spreadsheet template?
For example:

I have Excel 2000 and also 2002 for the PC.  I need to
send a simple speadsheet to another user that only has
Excel 98 on a Mac. Will they be able to open the file?

I use Excel on a commercial basis mainly apart from when I'm learning V
to put into proctise in my work.  I tend to need to locate details alo
and lots of the same details.  Is there a way that when I search fo
something if there are multiples of that data, all of the searc

I did a search in this forum for "concatenate" in the subject but could not
find any results.
Sorry if this has already been answered.
I have 2 columns with 208 rows each...I would like to concatenate each

I have a data that I'm importing into excel that looks similar to:
123456 012.  What I want to do is on this whole column trim everything
away and leave only the first 6 characters.  Is this something fairly
simple?

Is there a way to show the comments against a cell when printing a worksheet
out?
Regards
Ric

I have the following function which replaces a word in a sentence with
"....."
=REPLACE(I2,SEARCH(E2,I2),LEN(E2),".....")
Where the word is E2 and the sentence is I2.

I am running into a promblem when I use concatenate. Specifically, I
am trying to bring together the following cells:
A1 - Contains "N="
B1 - Contains "1,457"

I am ruinning Excel 2000. I have a workbook with external links (t
other workbooks). I want to delete those links, but cannot find them t
delete.
Ive even tried to (EDIT - CLEAR ALL) clear teh whole sheet, but th