Excel Excel 2010

Discussion in 'Microsoft Office' started by mosheavron, Jul 22, 2012.

  1. mosheavron

    mosheavron

    Joined:
    Jul 22, 2012
    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

    Joined:
    Mar 20, 2012
    Likes Received:
    3
    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. CathyDennis

    Excel Excel today's date as formula (seventeenth day of April 2010)

    CathyDennis, Apr 17, 2010, in forum: Microsoft Office
    Replies:
    0
    Views:
    512
    CathyDennis
    Apr 17, 2010
  2. hjf774

    Excel Excel 2010 Corrupt Files

    hjf774, Jun 10, 2010, in forum: Microsoft Office
    Replies:
    3
    Views:
    1,378
    hjf774
    Jun 11, 2010
  3. ElmerS

    Excel "Sparklines" (Excel 2010)

    ElmerS, Jun 17, 2010, in forum: Microsoft Office
    Replies:
    0
    Views:
    1,893
    ElmerS
    Jun 17, 2010
  4. stasker

    Excel Cannot save excel 2010 file

    stasker, Aug 26, 2010, in forum: Microsoft Office
    Replies:
    0
    Views:
    1,313
    stasker
    Aug 26, 2010
  5. Safetyman

    Excel Problem with x axis labels in Excel 2010 chart

    Safetyman, Oct 27, 2011, in forum: Microsoft Office
    Replies:
    2
    Views:
    5,169
    bootneck02
    Oct 27, 2011
  6. GWI

    Excel Excel 2010-how to display negative % with brackets

    GWI, Dec 2, 2011, in forum: Microsoft Office
    Replies:
    0
    Views:
    959
  7. jasmcduffie

    Excel Excel 2010 - How to change how an active cell is shown

    jasmcduffie, Dec 6, 2011, in forum: Microsoft Office
    Replies:
    2
    Views:
    867
    jasmcduffie
    Dec 6, 2011
  8. clayts
    Replies:
    6
    Views:
    1,159
    Fair Cape
    Feb 21, 2012
Loading...