PDA

View Full Version : [SOLVED] Remove last two characters from string



YellowLabPro
08-27-2007, 01:49 PM
This errors:
It seems to not like the Left


Cells(i, "W").Value = Left(Cells(i, "W") - 2).Value

Bob Phillips
08-27-2007, 01:52 PM
Cells(i, "W").Value = Left(Cells(i, "W").Value,Len(Cells(i,"W").Value) - 2)

YellowLabPro
08-27-2007, 02:11 PM
Thanks!