Required "IF(ISNUMBER(SEARCH" related formula

0 A2 0 C7GST-1 TRE20-0 /RTLTB2-1

CELL A1 having data like above & from “TRE20-0” I want to copy “TRE20” for the cell B1.
& from “/RTLTB2-1” I want to copy “1” for the cell C1. but if cell A1 having blank then B1 & C1 will be blank as well

& like this i have data till A65536
15 A2 0 C7GST-143 TRE20-15 /RTLTB2-47
1 A2 24 C7GSTAH-129&&-159 BSE24-1 /RTLTT2-2017
7 A2 0 C7GST-182 MGW03-7/RTLTB2-231

Hi, bebo thanks for respons here is my issue

* If there is no "TRE" in A1, B1 will be blank?

A1 will be “TRE” or “BSE” or “MGW” other then Blank

* Its alway "TRE-20" or sth else like "TRE-30",...?

Not always “TRE-20” ,

sometime it would be “TRE-X” ,Sometime “TRE-XX” & sometimes “TRE-XXX”
sometime it would be “BSE-X” ,Sometime “BSE-XX” & sometimes “BSE-XXX”
sometime it would be “MGW-X” ,Sometime “MGW -XX” & sometimes “MGW -XXX”
Here X means numeric number (0,1,3,4..)

*C1 is always a group of last number characters in A1, after the "-" ?

Yes you are correct. after the "-"