Number of Characters

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top