Append, Union, Or Update??

Hello

I have some different fields (cell content) in the same tables that need to be joined or merged together. Then I also have several fields that need to be joined from several different tables. I need to add a prefix to everything I add.

Here is a sample of the join I need within one table:

What I have:

|__JHOLDINGS__|__MOVINGWALL___|
|__V.30 1998-_|________5______|

What I want:

|___JHOLDINGS___|
|__V.30 1998-___|
|_____MW: 5_____|

Here's another sample of the join I need between two tables:

What I have:

Table 1: Super Table

|__________NOTES_________|
|__This title comes in___|
|__microfilm and PM______|

Table 2: Project MUSE

|__________NOTES_________|
|__This is a made-up_____|
|__note__________________|

What I want:

Table 1: Super Table

|__________NOTES_________|
|__This title comes in___|
|__microfilm and PM______|
|__Project MUSE: This is_|
|_ a made-up note________|

Table 2: Project Muse

Stays the same.

I know how to move part of a cell to another blank cell, and I know how to delete part of a cell.. But I don't know how to move part of a cell to a cell that already has content.

If you search for my name and this post: Deleting Certain Text Between Character in a Cell, you'll see what I've learned already. I'm thinking maybe I just need to run the same sort of function/module, but append instead of update. Dunno.

Thanks in advance,
Siena