+ Reply to Thread
Results 1 to 7 of 7

pulling certain data out of a cell

  1. #1
    D richardson
    Guest

    pulling certain data out of a cell


    I have a cell that contains l1931-06-05l73lyrs
    I want to be able to pull off just the 73, is this possible

  2. #2
    JulieD
    Guest

    Re: pulling certain data out of a cell

    Hi

    if your data is consistent with the example then you can use
    =MID(A1,13,2)
    or alternatively try
    =MID(A1,FIND("l",A1,3)+1,2)
    (with your data in A1)
    --
    Cheers
    JulieD
    check out www.hcts.net.au/tipsandtricks.htm
    ....well i'm working on it anyway
    "D richardson" <Drichardson@discussions.microsoft.com> wrote in message
    news:F06D7369-FBCB-47BC-A130-8F02F80641D3@microsoft.com...
    >
    > I have a cell that contains l1931-06-05l73lyrs
    > I want to be able to pull off just the 73, is this possible




  3. #3
    Guest

    Re: pulling certain data out of a cell

    Hi
    It depends on the criteria you are using and how similar the information is
    to your example. TO get 73 from the cell content you posted you could use:
    =MID(A2,13,2)
    which start at the 13th character and returns the next 2

    --
    Andy.


    "D richardson" <Drichardson@discussions.microsoft.com> wrote in message
    news:F06D7369-FBCB-47BC-A130-8F02F80641D3@microsoft.com...
    >
    > I have a cell that contains l1931-06-05l73lyrs
    > I want to be able to pull off just the 73, is this possible




  4. #4
    Jason Morin
    Guest

    RE: pulling certain data out of a cell

    Try:

    =SUBSTITUTE(RIGHT(A1,LEN(A1)-12),"lyrs","")*1

    Assuming the format is always:

    lyyyy-mm-ddl"age"lyrs

    HTH
    Jason
    Atlanta, GA


    "D richardson" wrote:

    >
    > I have a cell that contains l1931-06-05l73lyrs
    > I want to be able to pull off just the 73, is this possible


  5. #5
    patrick
    Guest

    RE: pulling certain data out of a cell

    This works if all your data is the same length. =MID(A1,13,2). Start at 13th
    character, return 2=73.
    Good Luck
    Pat

    "D richardson" wrote:

    >
    > I have a cell that contains l1931-06-05l73lyrs
    > I want to be able to pull off just the 73, is this possible


  6. #6
    D richardson
    Guest

    RE: pulling certain data out of a cell


    Thanks...Your right that worked assuming the length is always the same in
    some instances the lyyyy-mm-ddl is missing and you are left with ll45lyrsl,
    the lyrsl is a constant... is there a way to pull off from the right after
    the 5 characters lyrsl.

    "Jason Morin" wrote:

    > Try:
    >
    > =SUBSTITUTE(RIGHT(A1,LEN(A1)-12),"lyrs","")*1
    >
    > Assuming the format is always:
    >
    > lyyyy-mm-ddl"age"lyrs
    >
    > HTH
    > Jason
    > Atlanta, GA
    >
    >
    > "D richardson" wrote:
    >
    > >
    > > I have a cell that contains l1931-06-05l73lyrs
    > > I want to be able to pull off just the 73, is this possible


  7. #7
    D richardson
    Guest

    Re: pulling certain data out of a cell


    Thanks, your second suggestion worked for me with a slight adjustment
    changing the 3 to a 2. Thanks again.

    "JulieD" wrote:

    > Hi
    >
    > if your data is consistent with the example then you can use
    > =MID(A1,13,2)
    > or alternatively try
    > =MID(A1,FIND("l",A1,3)+1,2)
    > (with your data in A1)
    > --
    > Cheers
    > JulieD
    > check out www.hcts.net.au/tipsandtricks.htm
    > ....well i'm working on it anyway
    > "D richardson" <Drichardson@discussions.microsoft.com> wrote in message
    > news:F06D7369-FBCB-47BC-A130-8F02F80641D3@microsoft.com...
    > >
    > > I have a cell that contains l1931-06-05l73lyrs
    > > I want to be able to pull off just the 73, is this possible

    >
    >
    >


+ 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