Hi,

It doesn't matter if there are less than 241 characters, this works

myvalue = Left(myvalue, 241)

Mike

"N1KO" wrote:

I need to trim a series of cells so they only contain 241 characters. Does
anyone have any VBA code to make this quick and easy?

It needs to be the 1st 241 characters, everything else after that can be
deleted however i don't think i can use an =Right or =Trim to my knowledge as
the amount of characters in the cell isn't always the same (Anywhere between
40 & 390characters).