'is there a code or function in excel to: If F8=blank, cut and paste text in G8 in G7 next to text separated by semi-colon

Is there a code or function in excel to do the following:

If F8=blank, cut and paste text in G8 in G7 next to text separated by semi-colon.



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source