How do you use Excel to create memorandums?

The answer is coding it in VBA, the programming language shared by all Microsoft products. The base code would be in excel which is the source of your data (I assume). I’d create a VBA module in excel that would generate a Microsoft word template for whatever you are doing and execute code to place values from your data into your Microsoft word document. Then I would just use a macros button in excel probably right on your data spreadsheet that you would just click on when you have finished inputting your data. The button just executes the coding module previously described, and boom, instant memo with the right names and info. Not sure what organization you are in, but if you have ORSAs near you, then can help you set that up. Most of us are quite familiar with VBA. Also if you have any computer science types around you, they should know VBA.

Better off using word. You can get a template easily and much easier to manipulate in a word processor.

You can put links in cells to whatever you want. Create in Word and post a link to it in cell of spreadsheet. Spreadsheets are not user friendly for wordsmithing.