=MID(D2,FIND("[",D2)+1,FIND("]",D2)-FIND("[",D2)-1)
Retrieve NAA from RVTools report :
="naa."&LEFT(RIGHT(A2, LEN(A2)-10), LEN(RIGHT(A2, LEN(A2)-10))-12)
Excel
原文:https://blog.51cto.com/549687/2528018