获取[]里的内容

=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)