|
|
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($F1 5,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
|