Can you merge non-like spreadsheets inexcel?

Egypt is the Answer · Feb 21st, 2002, 02:39 PM

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 · Feb 23rd, 2002, 04:15 PM

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 · Feb 23rd, 2002, 04:44 PM

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 · Feb 24th, 2002, 11:17 AM

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 · Feb 24th, 2002, 12:42 PM

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

Feb 23rd, 2002, 04:15 PM	#2
Damon Ostrander MrExcel MVP Join Date: Feb 2002 Location: Denver, Colorado USA Posts: 4,014	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? __________________ Keep Excelling. Damon VBAexpert Excel Consulting (My other life: http://damonostrander.com )

Feb 24th, 2002, 12:42 PM	#5
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,064	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 __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 21st, 2002, 02:39 PM	#1
Egypt is the Answer New Member Join Date: Feb 2002 Posts: 1	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 ]

Feb 23rd, 2002, 04:44 PM	#3
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,064	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.

Feb 24th, 2002, 11:17 AM	#4
Rocky E Board Regular Join Date: Feb 2002 Location: North Alabama, USA Posts: 105	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...