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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Indent based on character length 4
How to remove characters in a cell that precede a specific hyphen 17
Epson XP-3150 not printing 2
Limiting the number of characters in a cell 5
Concantenating non adjacent cells 6
Concatenating non adjacent cells 2
Column Cell character number checking 4
Excel Formula Desperately Needed! 2

Back
Top