How to truncate cell contents to specified number of characters

C

Curtis Fray

Hi,

I have a column with about 30,000 entries (in Excel XP). I need to specify
the maximum length of the characters within each cell limits to the first 64
and deletes any characters after this if they exist.

Can anyone tell me how to do this?

Thanks,

Curtis.

====================================
When replying by email please remove the X
====================================
 
F

Frank Kabel

Hi
use 'Data - Text to columns', specify a fixed length and delete the not
required columns afterwards
 
P

Peo Sjoblom

You can use a help column (maybe in another sheet or a new workbook,
then use a formula like

=LEFT(TRIM(Sheet1!A1),MIN(LEN(TRIM(Sheet1!A1)),64))

this will return all characters of data that is less than 64 characters and
64 characters of those that are more than 64

after you are done, copy and paste special as values in place


Regards,

Peo Sjoblom
 
Top