Sorry, I'm just now realizing that the posts were from two different people. Thought it was the same source.
Ok, I just tested......for the example BSHPFRSUR46020-200, it is returning 020 versus just 20. And it is making the answer all text, whereas they need to be values, so that I can calculate on them. I could just multiple the result by 1 to turn into a value. But, what about the 020 versus the needed 20?
Thanks
I'd assumed you might want to see the leading zeros.
Since you don't, try this slight variation:
B2: =INDEX(--RIGHT(LEFT(A1,FIND("-",A1&"-")-1),{3,2,2}),MATCH(1,--ISNUMBER(--RIGHT(LEFT(A1,FIND("-",A1&"-")-1) ,{5,4,3})),0)) or B2: =IFERROR(INDEX(--RIGHT(LEFT(A1,FIND("-",A1&"-")-1),{3,2,2}),MATCH(1,--ISNUMBER(--RIGHT(LEFT(A1,FIND("-",A1&"-")-1) ,{5,4,3})),0)),"")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks