How to truncate cell contents to specified number of characters

  • Thread starter Thread starter Curtis Fray
  • Start date Start date
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
====================================
 
Hi
use 'Data - Text to columns', specify a fixed length and delete the not
required columns afterwards
 
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
 
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

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Column Cell character number checking 4
Excel truncating imported file to 256 characters per cell - Help 2
limit on number of characters? 1
Solve the Mystery of the Truncating Text 3
Comparing characters in cells 7
Intentionally truncating text characters 2
2007 cell character limit 11

Back
Top