+ Reply to Thread
Results 1 to 9 of 9

Formula Question:that will return only partial data from one cell to another?

  1. #1
    Joe
    Guest

    Formula Question:that will return only partial data from one cell to another?

    Is there a formula that will return only partial data from one cell to another?
    Ex. Cell D1 contains (5^Inlet) And I want to write a formula that will only
    return the number 5 of cell D1 to Cell A1. Is this possible?

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,918
    Yes:
    "=MID(source,start,length)"
    For the example given:
    Source = D1,
    start = 1, i.e., the first character in the string,
    length =1, i.e., the number of characters to copy

    Of course, if number of characters to be copied varies, as I suspect, it gets more complicated, nor did you explain the significance of the caret after the '5' character.

  3. #3
    tim m
    Guest

    re: Formula Question:that will return only partial data from one cell to another?

    For your specific example you could use the function 'LEFT'

    =LEFT(D1,1) This will look at cell D1 and return the left most character.

    "Joe" wrote:

    > Is there a formula that will return only partial data from one cell to another?
    > Ex. Cell D1 contains (5^Inlet) And I want to write a formula that will only
    > return the number 5 of cell D1 to Cell A1. Is this possible?


  4. #4
    JE McGimpsey
    Guest

    re: Formula Question:that will return only partial data from one cell to another?

    If the number is always left paren followed by one digit:

    D1: =--MID(A1,2,1)

    if there may be more digits, but they're always followed by a caret (^):

    D1: =--MID(A1,2,FIND("^",A1)-2)


    In article <7F5E5A74-A9C8-4EE5-B0C8-9E1F312A0E41@microsoft.com>,
    Joe <Joe@discussions.microsoft.com> wrote:

    > Is there a formula that will return only partial data from one cell to
    > another?
    > Ex. Cell D1 contains (5^Inlet) And I want to write a formula that will only
    > return the number 5 of cell D1 to Cell A1. Is this possible?


  5. #5
    Joe
    Guest

    re: Formula Question:that will return only partial data from one cell to another?

    Thanks for the help.

    "JE McGimpsey" wrote:

    > If the number is always left paren followed by one digit:
    >
    > D1: =--MID(A1,2,1)
    >
    > if there may be more digits, but they're always followed by a caret (^):
    >
    > D1: =--MID(A1,2,FIND("^",A1)-2)
    >
    >
    > In article <7F5E5A74-A9C8-4EE5-B0C8-9E1F312A0E41@microsoft.com>,
    > Joe <Joe@discussions.microsoft.com> wrote:
    >
    > > Is there a formula that will return only partial data from one cell to
    > > another?
    > > Ex. Cell D1 contains (5^Inlet) And I want to write a formula that will only
    > > return the number 5 of cell D1 to Cell A1. Is this possible?

    >


  6. #6
    Joe
    Guest

    re: Formula Question:that will return only partial data from one cell to another?

    yes there may be more than one digit before the ^. 2 digits maximum ex.
    10^Inlet
    the ^ stands for offset. A symbol we use. All I want to do is return the
    number before the ^ to another cell as I explained before.

    "Joe" wrote:

    > Is there a formula that will return only partial data from one cell to another?
    > Ex. Cell D1 contains (5^Inlet) And I want to write a formula that will only
    > return the number 5 of cell D1 to Cell A1. Is this possible?


  7. #7
    TKnTexas
    Guest

    re: Formula Question:that will return only partial data from one cell to another?

    Wouldn't the formula be:

    =left(A1,find("^",A1,1)-1)


  8. #8
    TKnTexas
    Guest

    re: Formula Question:that will return only partial data from one cell to another?

    Wouldn't the formula be:

    =left(A1,find("^",A1,1)-1)


  9. #9
    JE McGimpsey
    Guest

    re: Formula Question:that will return only partial data from one cell to another?

    The OP's example has a left paren before the 5, so you'd use
    MID(A1,2,...) rather than LEFT(A1,...)

    In article <1147580293.868472.78770@v46g2000cwv.googlegroups.com>,
    "TKnTexas" <tkntexas55@aol.com> wrote:

    > Wouldn't the formula be:
    >
    > =left(A1,find("^",A1,1)-1)


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1