I actually want to leave 24 and remove the rest

"Gary''s Student" wrote:

Yes. How many do you want to remove??
--
Gary's Student


"Murray" wrote:

Hi all
Is there a method to remove excess charachters for a cell. I have a sheet I
receive from a work mate and the field length is not set, I want to go
through the cells and remove the excess characters.

Thanks