Posts by navneethkumar

    i have text document with lines 1000 lines long which is copied to word


    first 5 charater as space
    next 45 non space character
    other 950 charater as spaces


    now i need to trim the first and the last spaces . After selecting the line and copying it to a string variable a


    ltrim$(rtim$(a)) does not work
    or ltrim(rtim(a)) does not work
    also trim(a) does not work


    how do i trim such lines pls help me


    thanks in advance