Hi

Look at the placement of -1 in the parantheses:

Range("G" & x) = Right(Range("F" & x), Len(Range("F" & x)) - 1)
Range("I" & x) = Right(Range("H" & x), Len(Range("H" & x)) - 1)

Regards,
Per

"EXCELMACROS" skrev i meddelelsen
...
hi, could someone see what's the problem with the following:

For x = 2 To lastrow
Range("G" & x) = Right(Range("F" & x), Len(Range("F" & x) - 1))
Range("I" & x) = Right(Range("H" & x), Len(Range("H" & x) - 1))
Next x

I just want it to see the previous cell and take one blank space out of
the
way. (trim does not work, i.e. " 3.5" and I need "3.5")

--
Thank you...