# pulling certain data out of a cell

1. ## 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. ## 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)
--
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. ## 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. ## 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. ## 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. ## 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. ## Re: pulling certain data out of a cell

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

>
>
>

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

#### 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