Limit number of chacters in cell

G

Guest

I have an an excel sheet that has a list of 18,000 items. I need to import
them into a system that can only handle 30 characters per cell. I have
several cells that are easily over 40 characters.

Does anyone know how I can cut off the last characters? Say that it had 40
characters, I need to strip off the last 10.

Thanks!
 
G

Gord Dibben

Assuming the 18000 items are in Column A

In Column B enter =LEFT(A1,30)

Double-click the fill handle to copy down.

When happy, copy column B>paste special(in place)>values>ok>esc.

Delete column A


Gord Dibben MS Excel MVP
 

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

Top