Excel 2010

Discussion in 'General Software' started by mosheavron, Jul 22, 2012.

  1. mosheavron

    mosheavron

    Joined:
    Jul 22, 2012
    Messages:
    1
    Likes Received:
    0
    How to undo a CONCATENATED file created by CONCATENATING two columns?

    mosheavron
     
    mosheavron, Jul 22, 2012
    #1
    1. Advertisements

  2. mosheavron

    alow Excel Formulator VIP Member

    Joined:
    Mar 20, 2012
    Messages:
    760
    Likes Received:
    0
    Location:
    US
    What does the data look like now? It depends on if the stuff you want to separate out is all the same length, or if there is a variable to it. If you wanted to take the first 5 characters in one column and the last 7 characters in another, you would use =RIGHT(a1,5) in one column, and =LEFT(a1,7) in another to pull it apart.
     
    alow, Jul 23, 2012
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. hjf774

    Excel 2010 Corrupt Files

    hjf774, Jun 10, 2010, in forum: General Software
    Replies:
    3
    Views:
    1,156
    hjf774
    Jun 11, 2010
  2. ElmerS

    "Sparklines" (Excel 2010)

    ElmerS, Jun 17, 2010, in forum: General Software
    Replies:
    0
    Views:
    1,613
    ElmerS
    Jun 17, 2010
  3. Safetyman

    Problem with x axis labels in Excel 2010 chart

    Safetyman, Oct 27, 2011, in forum: General Software
    Replies:
    2
    Views:
    4,063
    bootneck02
    Oct 27, 2011
  4. GWI
    Replies:
    0
    Views:
    708
  5. jackb1117
    Replies:
    0
    Views:
    1,305
    jackb1117
    Sep 24, 2012
Loading...

Share This Page