Hello from Steved

Below will return the first numeric ie 4001 it will return 4
ok I would like to please to have P4001 return P4 off P4001
is this possible

=IF(ISERROR(VALUE(LEFT($F15,1))),"",VALUE(LEFT($F15,1)))

Thankyou.

Please Ignore.

"Steved" wrote:

> Hello from Steved
>
> Below will return the first numeric ie 4001 it will return 4
> ok I would like to please to have P4001 return P4 off P4001
> is this possible
>
> =IF(ISERROR(VALUE(LEFT($F15,1))),"",VALUE(LEFT($F15,1)))
>
> Thankyou.

Steved Wrote:
> Hello from Steved
>
> Below will return the first numeric ie 4001 it will return 4
> ok I would like to please to have P4001 return P4 off P4001
> is this possible
>
> =IF(ISERROR(VALUE(LEFT($F15,1))),"",VALUE(LEFT($F15,1)))
>
> Thankyou.

Hi Steved

Try > =IF(ISERROR(LEFT($F15,2)),"",(LEFT($F15,2)))


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=465739

Thankyou Paul.

"Paul Sheppard" wrote:

>
> Steved Wrote:
> > Hello from Steved
> >
> > Below will return the first numeric ie 4001 it will return 4
> > ok I would like to please to have P4001 return P4 off P4001
> > is this possible
> >
> > =IF(ISERROR(VALUE(LEFT($F15,1))),"",VALUE(LEFT($F15,1)))
> >
> > Thankyou.
>
> Hi Steved
>
> Try > =IF(ISERROR(LEFT($F15,2)),"",(LEFT($F15,2)))
>
>
> --
> Paul Sheppard
>
>
> ------------------------------------------------------------------------
> Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
> View this thread: http://www.excelforum.com/showthread...hreadid=465739
>
>