I'll do my best to explain what situation I have and what I need to be done.
I have an excel book containing a database of citations of articles, with information such as Title, Author, Year, Abstract etc.
In the database I have multiple tabs of different categories, and there are duplicates across tabs.

I have used SPSS to aggregate the different categories into one database, merging duplicates and tagging each article with all the different categories it previously appeared in. However the problem is when creating the excel book from SPSS for some reason the string length for each field was limited to 255 characters. So the abstracts in the aggregated excel database are cut short.

What I want to try and do is copy the corresponding full abstracts...