I'm trying to present (text) data from multiple cells in another
workbook in a single cell. I've tried the following formula but it
returns a #VALUE! in my destination cell:
='[Project1.xls]Dependencies'!$A$6, '[Project1.xls]Dependencies'!$A$7

i have a shared excel file in the server and my OS is windows nt.then my
file have change its filename to 494F6100 from SCS.582SR. and the type of
file was change to File from microsoft excel worksheet.
can you help me what are the possible cause of this?

I'm going to fill out an excel sheet that later will bee converted to
other program. To get the converting right each cell needs to have
certain length (same length for the entire column). Like column A
should have 5 characters and column B 15 characters. Some times a cell

I have a macro that allows me to enter spinners for a range of cells
(R7:R100)
The problem I have is I would like to format control them all in one
for each incremental cell value :

I would like to autofill 1,2,3,4,5 etc. in a column but I only want
number every 48th row i.e.
1
47 rows inbetween

I have a roster with 30 names on a fixed schedule for 15 weeks i want to move
the names through the schedule.
Thanks

Is it possible to combine the text contents of two cells and extra
characters sing a formula?
i.e. Result required A2(B2) in uppercase
The uppercase thing is not as necessary as the combined content and inserted

Hi  I  am trying  to apply a range  between B6:N35  however  whenever  I  
select  B6 , i am told in Microsoft ,version4 page32 to  hold  the  control
button  and  select the  other cells  when i do that  and  try to apply
Autoformat  i get  a error  message,  any advice would  be ...

Could some kind person assist with this?
Main data on a range is split by macro into several worksheets and each
worksheet get named as the result of the filtered split (i.e. if column A of
main data is entered with various rows cat dog rat there will be worksheets

Now it is working. Thanks Thanks Thanks.
Yours truly pupil
RRS

I copied my contacts from another email program and they came out as Excel
spreadsheet. The file is on my desktop.How do I get them converted and into
OUtlook???

ok i have a dilemma, im pretty new to excel and havent been able to find
the solution anywhere on google.
in cells C14,E14,G14,I14,K14,M14 i have SUM functions, I want to
average the results of the SUM functions in another cell, however i

I want to be able to count the number of cells that have coloured text from a
range of cells. Is their a way to do this, I tried "countif" but was unable
to get it working.
Thanks

Can Excel find & sort one item in all the cells in a column?  My list
contains items that I want to assign to one or more categories in a single
'categories' column.  If I assign a numeral to each category, then some items
will have one numeral and some will have several.  Is ...

how to use data to create charts and database funcions as =dbmax, etc.. from
the a data in sheet1 variable ?
Because the data is import and I not know the total lines from range of the
table...