Hi
use left. e.g.
with activecell
.value=left(.value,len(.value)-1)
end with

--
Regards
Frank Kabel
Frankfurt, Germany


Franck wrote:
how to use the right function with vba to remove the last caracter of
the data of my colums

thanks