I would like to know if there is some code that can help me with the
following.

I have a column of cells with information similar to this:
$50.00 Gift from Johnson, John
$35.00 Gift from Public, Jimmy
$75.00 Gift from Jones, Billy
etc.
The second part (Gift...) is not necessarily lined up vertically.

I would like to move the "Gift from Johnson, John" part to a new column.

Thanks for your help,
Scott