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

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.

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.

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.

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.

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/

Thankyou Paul.

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

Thankyou BenjieLop

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

Sorry pushed the button by accident.