Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: linking and splitting a cell's contents

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

    Default

    I am trying to link a cell from one worksheet to another. But I want to take cell A1 from worksheet 1 and take the first half of the contents in A1 and put it in B2 worksheet2 then take the second half of the contents in A1 and put it in B3 in workshet 2.

    For EX:

    123/345 Cell A1 worksheet 1
    123 Cell B2 worksheet 2
    345 Cell B3 worksheet 3

    How do I accomplish through through links?

    Thanks

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,648
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    6 Thread(s)

    Default

    On 2002-03-22 09:19, lsutaylor wrote:
    I am trying to link a cell from one worksheet to another. But I want to take cell A1 from worksheet 1 and take the first half of the contents in A1 and put it in B2 worksheet2 then take the second half of the contents in A1 and put it in B3 in workshet 2.

    For EX:

    123/345 Cell A1 worksheet 1
    123 Cell B2 worksheet 2
    345 Cell B3 worksheet 3

    How do I accomplish through through links?

    Thanks
    In B2 in Sheet2 enter:

    =LEFT(Sheet1!A1,SEARCH("/",Sheet1!A1)-1)

    In B3 in Sheet2 enter:

    =RIGHT(Sheet1!A1,LEN(Sheet1!A1)-SEARCH("/",Sheet1!A1))

    Select B2:B3 and drag down if required.

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
  •