Software

Ask something
Discussion Locked

2 Files in Excel

0 helpful
6 replies

by jacmari

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hello there...

I have two Excel files with the same fields (columns). I would like to merge these two files into one without doing a "cut and paste". How do I go about doing that?

I'm using Windows 2000 and Excel 2000.

Thank you in advance. If you need more info, please let me know. Thanks again,

-- Jackie

6 replies

by tesfa.tadesse

eg i have a file called TOM and another called JOHN

in tom file in the first cell (A1)i have apple
in JOHN file in the first cell (A1)i have banana

if i want to merge these two in a diferent file
then =A1&A1 (cell A1 From Tom File & cell A1 From John File)

this should work

the result you get is "applebanana"

by jacmari

Here's what I want to do: One of my files has records till Row 1120, and I want to add the second file at Row 1121.

Is there a way to do it without cutting and pasting? Sorry if the word Merge was referenced wrong.

-- Jaclyn

Thank you once again!

This discussion is closed to new replies.