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