Limit number of chacters in cell
 

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!

Limit number of chacters in cell
 

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 Bpaste special(in place)valuesokesc.

Delete column A


Gord Dibben MS Excel MVP

On Tue, 20 Feb 2007 10:17:38 -0800, plunk25
wrote:

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!