Results 1 to 4 of 4

Thread: Copy/Paste part of a cell?
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Jun 2011
    Posts
    39
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Copy/Paste part of a cell?

    Hey guys,

    I want to know how to copy part of a cell and paste it into a new cell.

    Example:

    a1= 8hAs7c

    portion needed: 7c


    I used this formula:

    =RIGHT(A1,2)

    This returns 7c like I want.

    However in the next cell I want to source the middle two (As)

    And in another cell I want the first two (8h)

    How do I go about this?

  2. #2
    Board Regular
    Join Date
    Apr 2009
    Posts
    1,047
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Copy/Paste part of a cell?

    Is this what you are looking for?

    Sheet1

     AB
    18hAs7c7c
    2 As
    3 8h

    Spreadsheet Formulas
    CellFormula
    B1=RIGHT(A1,2)
    B2=MID(A1,3,2)
    B3=LEFT(A1,2)


    Excel tables to the web >> http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4
    Show your sheet on the board, get MrExcel HTML Maker or Excel Jeanie

    Using Excel 2010 on Windows 7

  3. #3
    New Member
    Join Date
    Jun 2011
    Posts
    39
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Copy/Paste part of a cell?

    Yes thats perfect! Thanks very much!

  4. #4
    Board Regular
    Join Date
    Apr 2009
    Posts
    1,047
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Copy/Paste part of a cell?

    You're Welcome.

    And thanks for the feedback.

    Nothing better than a "Thank You"
    Show your sheet on the board, get MrExcel HTML Maker or Excel Jeanie

    Using Excel 2010 on Windows 7

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
  •