You mention Word but what about transitioning to Access? It sounds like you are using Excel as a database now.
Hello, I've currently got one excel sheet with a large amount of private data and I have been using another sheet with a v-look up to pick out the parts I need.
I now have cells with more than 255 characters and v-look up doesn't seem to pick up anything beyond that. (I've searched the web and although i've found lots of people with similar problems, can't find a helpful way round)
Can anyone suggest a work around?
I'm willing to move to word. But I can't use VBA.
Or can anyone give me a formula that checks for more than 255 characters and a second formula to pick up the remains?
I'm desperate.

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic