Can you merge non-like spreadsheets inexcel?

[Egypt is the Answer]

How would I get 2 different spreadsheets, both having a column of identical, yet unsorted, information, into one new spreadsheet. I want to have excel merge the information that is not similar.

IE.... XYZR + XPSE = XYZRPSE

Is this possible??
This message was edited by Egypt is the Answer on 2002-02-21 13:40
This message was edited by Egypt is the Answer on 2002-02-21 13:45

 

[Damon Ostrander]

Hi Egypt,

I have to admit that I'm mystified by your question, so I'm thinking that maybe other readers are too. Could you provide some clarification? When you say

XYZR + XPSE = XYZRPSE

What do X, Y, Z and R stand for. Are these columns? Or perhaps you are referring to characters and you and to concatenate text in the merged worksheet? Can you provide a more specific example?

 

[Jack in the UK]

Hi

Assuming the dat in non excel is data text or number thats is no formula as they will most prob be lost and you say say lay out copy all to new sheet

Sheet 1 = excel sheet
Sheet 2 = non excel sheet
Sheet 3 = both as you want

Put this in A1
=TEXT(Sheet1!A1,0)&TEXT(Sheet2!A1,0)

This will bring over the data asuming you paste into cell A1 also

All data will be text and formulas formatting will be lost but does as you ask

Drag down as reqd and across to fill area you req. Can copy and paste as value to kill formula,

Put 1 in any unused cell and copy it select all and spaste special and multiply

this will bring numbers back to values so formulas will work on them in future.

 

[Rocky E]

Sometimes simple the works best. MS cut-n-paste works very well and paste special is a real time saver. Well I would not expect most of my co-workers to use them daily. I save enormous amounts of personal time even though I can program a little. You can even cut-n-paste from html tables with just a little extra work. Anything that is tabular is fair game.

Columns don't match or need to parse one just copy to an empty sheet first.

With you columns already being lined up all you should need is to cut and paste or past special.

HTH

Rocky...

 

[Jack in the UK]

Hi

very good points but i dont want to upset but your post is fine but does not answer the questionat all, the question was to joing Excel sheets data to non excel sheets data all fully same column alinged.

So thats why copy past fails as the result but i did comment thats the way to get the data into Excel then apply som magic to answer the rest of the question.

Im not hightlighting tjis ti offend but i think my readeing is OK even if English not so goos!

Rdgs