Power Query Course in Spanish
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Can you merge non-like spreadsheets inexcel?

  1. #1
    New Member
    Join Date
    Feb 2002
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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 ]

  2. #2
    MrExcel MVP Damon Ostrander's Avatar
    Join Date
    Feb 2002
    Location
    Denver, Colorado USA
    Posts
    4,239
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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
    LinkedIn Profile http://www.linkedin.com/pub/damon-ostrander/7/79/a93
    AllExperts Profile http://www.allexperts.com/ep/1059-30...-Ostrander.htm

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.


  4. #4
    Board Regular
    Join Date
    Feb 2002
    Location
    North Alabama, USA
    Posts
    105
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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...

  5. #5
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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"

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •