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.

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.

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.

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.

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:

The formula

=LEFT($F15,*2*)

is what you need.

Regards

-----------------------------------------------------------------------

BenjieLop's Profile: http://www.yqcomputer.com/

View this thread: http://www.yqcomputer.com/

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/

1. no sound with first receive e-mail, sound ok if outlook left open

2. My I's are coming up i's. (lower case)

3. First outlook window frozen, second one OK.

4. Quick one..Is one stylesheet per site ok?

5. Ok, one problem sorted, one more to go....

6. OK.rb's First Meeting Reminder--One Week From Today

7. One User Can't Change Desktop Color on One TS, Others OK!

8. Sort 2 lists - one w/ last, first name // one w/ first, last name

9. Sort 2 lists - one w/ last, first name // one w/ first, last n

10. One man,one goat,one cabbage and one wolf

11. How do I set a rule for moving one cell down + one left in Excel?

12. Finding Dups in one column then delete leaving one

13. my first attemp at a function... one error left, but not sure why

14. My adjustable tabs, the one on the left and one at the top

15. Move contents of selected cell down one, and to the left one cell?

10 post • Page:**1** of **1**