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

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

Post by U3RldmV » Fri, 09 Sep 2005 06:55:02


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.
 
 
 

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

Post by U3RldmV » Fri, 09 Sep 2005 06:59:05

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.

 
 
 

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

Post by U3RldmV » Fri, 09 Sep 2005 07:05:03

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.
 
 
 

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

Post by U3RldmV » Fri, 09 Sep 2005 07:09:03

Please Ignore.
 
 
 

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

Post by U3RldmV » Fri, 09 Sep 2005 07:10:02

Please Ignore
 
 
 

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

Post by BenjieLo » Fri, 09 Sep 2005 07:13:50


Steved Wrote:

The formula

=LEFT($F15,*2*)

is what you need.

Regards

-----------------------------------------------------------------------
BenjieLop's Profile: http://www.yqcomputer.com/
View this thread: http://www.yqcomputer.com/
 
 
 

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

Post by Paul Shepp » Fri, 09 Sep 2005 08:01:26


Steved Wrote:

Hi Steved

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


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.yqcomputer.com/
View this thread: http://www.yqcomputer.com/
 
 
 

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

Post by U3RldmV » Fri, 09 Sep 2005 08:29:04

Thankyou Paul.
 
 
 

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

Post by U3RldmV » Fri, 09 Sep 2005 08:30:01

Thankyou BenjieLop
 
 
 

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

Post by U3RldmV » Fri, 09 Sep 2005 11:19:05

Sorry pushed the button by accident.