right function

[Franck]

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

thanks

 

[Tom Ogilvy]

You wouldn't use Right. You would use left

lCol = 2
for each cell in Range(Cells(1,lCol),Cells(rows.count,lCol).End(xlup))
cell.Value = Left(Cell.Value,len(Cell.Value)-1)
Next

 

[Frank Kabel]

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

 

[Bob Phillips]

or even Mid

for each cell in Range(Cells(1,lCol),Cells(Rows.Count,lCol).End(xlup))
cell.Value = Mid(cell.Value,1,Len(cell.Value)-1)
Next

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Franck]

Thanks to all