VBA字串處理

假設對OrgStr做處理

Dim OrgStr AS String

OrgStr = "123ABC"

1. 取的字串長度

    Dim StrLength As Interger

    StrLength = Len(OrgStr)

    

    'StrLength=6

2. 取得OrgStr某一字元或字串位置

    

    Dim pos AS Interger

    pos =  InStr(OrgStr, "A")

   

    'StrLength=4

3. 分割成子字串

    

   保留右邊幾個字元

    

    Dim SubStr AS String

    SubStr = Right(OrgSTR,1) ' Return C

    SubStr = Right(OrgSTR,2) ' Return BC

    保留左邊邊幾個字元

    

    Dim SubStr AS String

    SubStr = Left(OrgSTR,1) ' Return 1

    SubStr = Left(OrgSTR,2) ' Return 12