Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Garland, Texas, USA
    Posts
    140
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Moving 'find' results to new cell (Excel 2003)

    I need a formula that will allow me to extract the number from parentheses in a cell, move the number to an adjacent cell, and delete it and the parentheses from the original cell, leaving just the numbers in the adjacent cells (see attachment). I want to covert column A into columns B and C. Can anyone help me out? <img src=/S/confused3.gif border=0 alt=confused3 width=45 height=45>

    Thanks,

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Moving 'find' results to new cell (Excel 2003)

    In B2:
    <pre>=VALUE(LEFT(A2,FIND("(",A2)-1))</pre>

    In C2:
    <pre>=VALUE(MID(A2,FIND("(",A2)+1,FIND(")",A2)-FIND("(",A2)-1))</pre>


    Copy (autofill) B2:C2 to B3:C21

    Steve

  3. #3
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Garland, Texas, USA
    Posts
    140
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Moving 'find' results to new cell (Excel 2003)

    Thank you. Worked perfectly. <img src=/S/clapping.gif border=0 alt=clapping width=19 height=23>

Posting Permissions

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