Merging Two Spreadsheets

[Norm & Debbie]

Group,

I have two spreadsheets that are membership lists - one is an older one and
the other is a newer list. The newer list came from a DOS-based program
(don't ask). It has numerous spelling errors from being translated from the
DOS-based program.

How can I merge the two with the new data indicated and keep the corrections
I've made to the older list?

Thanks!

Norm

 

[Marin Kostov]

Try Data - Import External Data - Import Data. Choose your File of Types,
locate the File... and import it. Choose where to insert the Data - in the
current worksheet, or in new one.
Hope this helps.