| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Compare Question
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there a way to compare 2 spreadsheets with Excel? | Excel Discussion (Misc queries) | |||
| compare tables | Excel Discussion (Misc queries) | |||
| Compare Columns | Excel Discussion (Misc queries) | |||
| Excel should be able to compare 2 spreadsheets to find differing . | Excel Discussion (Misc queries) | |||
| compare columns of different worksheets | Excel Discussion (Misc queries) | |||
Threaded Mode
