Hi,

Just to add to previous posts truncation may also be done by selecting the
single column range and then doing Data - text to columns - Fixed width -
click on 19 from the scale and enter.

--
Thanks a lot,
Hari
India

"nick" wrote in message
...
I have two list. One was generated from an old DOS program using the
print to file option the other is a regular list in Excel. The problem
is the list that was generated using the print to file option
truncated the NAME field to 19 characters. The other list has full
name. The question is is it possible to compare the values of cells
using the first 10 characters or is there a way to truncate the full
name file to 19 characters then compare the two?

Any help would be appriciated.