# ok for the first but I would like the first 2 Left please.

=?Utf-8?B?U3RldmVk?=
Guest
Posts: n/a

 7th Sep 2005
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.

=?Utf-8?B?U3RldmVk?=
Guest
Posts: n/a

 7th Sep 2005

"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.

Paul Sheppard
Guest
Posts: n/a

 8th Sep 2005

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

=?Utf-8?B?U3RldmVk?=
Guest
Posts: n/a

 8th Sep 2005
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
>
>

 Thread Tools Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post DDC ATI Video Cards 18 1st Nov 2005 01:03 AM =?Utf-8?B?U3RldmVk?= Microsoft Excel Worksheet Functions 1 8th Sep 2005 03:19 AM =?Utf-8?B?U3RldmVk?= Microsoft Excel Worksheet Functions 3 8th Sep 2005 12:30 AM IBMclerk7781226@yahoo.com Windows XP General 3 18th Apr 2005 02:30 AM RegularJoe DIY PC 3 3rd Dec 2003 04:21 AM

Features