Let's say your data is in column A.

In B1 enter:
=LEFT(A1,24)
and copy this down the column

Column B will contain the data in column A reduced to the first 24 characters

--
Gary's Student


"Murray" wrote:

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