BSE23-0/RTLTT2-1
TRE20-15/RTLTT2-47
MGW01-15/RTLTT2-485
MGW01-15/RTLTT2-23456
Above is the exemple data. how to separate last numeric character whice is separate by "-". & after that it will
"int" by 32. [int (100/32)]
BSE23-0/RTLTT2-1
TRE20-15/RTLTT2-47
MGW01-15/RTLTT2-485
MGW01-15/RTLTT2-23456
Above is the exemple data. how to separate last numeric character whice is separate by "-". & after that it will
"int" by 32. [int (100/32)]
For up to 5 digits try
=INT(LOOKUP(10^5,RIGHT(A1,{1,2,3,4,5})+0)/32)
Audere est facere
hi,daddylonglegs,
it is working which you given thanks for you time..
IF(D9="","",INT(RIGHT(D9,LEN(D9)-FIND("-",D9,FIND("-",D9,1)+1))/32))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks