Merging Data

[rijujohn]

Hi,

I want to Know is there a way where i can merge Data from different (20-30 files) *.xls OR *.csv files into 1 one new excel sheet.

Please help...

 

[VoG]

This should help you http://msdn.microsoft.com/en-us/library/cc837974.aspx

 

[Dag]

Sure and easily.
For example:
=CONCATENATE(Value1,Value2," empty ", Value3) . . .
Or simple:
=Value1
=Value2
. . .
Be more specific.

 

[rijujohn]

Hi,

Thanx for the link...

I'm Quite new to Excel.. I tried using the 2nd Link.. But all it did was copy the file names into 1 sheet..

Is there any way i can fix that???

 

[rijujohn]

i know CONCATENATE formula but in VALUE.. what do i paste???