wrong data type

[petefa]

Hi,
I am trying this formula and it fails with #VALUE! if there IS the correct data and mentions wrong data type.
Formatting column B as number does not help.

Columm B
Row 1- A-RSC-350H-SC-ANG-300010
Row 2- B-RSC-350H-ST-ASM-300040

Column F
=IF(ISERROR(FIND("ASM",B1,15)),"FALSE",--MID(B1,15, FIND("ASM",B1)-12))

=IF(ISERROR(FIND("ASM",B2,15)),"FALSE",--MID(B2,15, FIND("ASM",B2)-12))

Row 1- returns FALSE
Row 2- returns #VAULE!

I want to return ASM or ANG or what ever it finds at location 15, +2

ASM
ANG
BOX

there are many more

The end result is to automatically paste each group onto different sheets

Sheet 2
B-RSC-350H-SC-ANG-300040

Sheet3
A-RSC-350H-ST-ASM-300010

I hope this is clear enough

 

[RoryA]

If you just want the three characters from position 15, you want:
=MID(B2,15,3)
The -- is causing your error since the value you are returning is text, not a number.

 

[petefa]

Many thanks Rory!

Correct answer to my question.

Pete