A fair point Oeldere. Thank you! Teach me to be in a hurry

Here is an example of the spreadsheet before applying the macro:
Before Sample.xlsx

And here is an example of the spreadsheet after applying the macro:
After Sample.xlsx

In this example upon executing the macro, I would be prompted with a message box asking me to identify the column to search.
I selected or entered column H
A text box would then ask me to enter the word to find. I would enter "April 13,"
Another message box would then ask me to identify the target column.
I would select column B
Finally, a message asks me to enter the text to be appended.
I would enter "; Armenian"
the macro would search for the text "April 13," in each cell.
Finding "April 13," in H2, the macro would append the string "French; German; English" at B2 with the term "; Armenian" to create "French; German; English; Armenian"
The macro would then move onto H3, and would create "French; Armenian" in B3
At row 4, the system would just enter "Armenian" (I know, the "; "... just thought of that and don't know how to deal with it. Any brilliant ideas?)
At row 5, because "April 13," does not appear at H5, B5 remains "Klingon, Unicorn" but no "; Armenian"
And so on...

This example brings up another completely different concern. Notice that the person who came before me wasn't very consistent. Sometimes they used ";" and other times they used ",". There are also random carriage returns and extra trailing spaces in different cells. Any idea how to consistently get rid of these?

Sorry if that is too long and drawn out, or if it put anyone to sleep. I really appreciate the help on this. I'm trying to learn, but like I said, this is way out of my league right now.

Thanks,
Rob