Limit number of chacters in cell

P

plunk25

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

Similar Threads

Is there a maximum number of characters allowed in a cell? 1
Limitations on Sumif Calculation 3
Excel text export limit - 1024 per line (not cell), workaround? 11
cant export to excel unless I reduce data in cells and line breaks 0
limit number of characters in cell 4
Limiting the number of characters in a cell 5
How to limit the number of characters in a cell? 5
custom text fields 0

Top