Truncating Existing Entries

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
 
D

Dave Peterson

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.
 
Top