Truncating Existing Entries

  • Thread starter Thread starter lrod1843
  • Start date Start date
L

lrod1843

i want to truncate anything past the 7th character. is there a way to d
this? The data is pretty uniform, usually has about 12-15 characters
if that helps
 
Use a helper column of cells with a formula like:

=left(a1,7)

drag down.
convert to values and delete the original column if you want.
 
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
Intentionally truncating text characters 2
No. of characters in an Excel column 2
Truncating text field in column 2
How do I recover text that was truncated/ deleted in Excel? 1
problem importing text into excel 2007 2
mailmerge maximum field size 2
Truncate a data entry cell 3

Back
Top