Text to Columns / Split first & last text in string

Hi All,
Sorry if this has already been asked - but I couldn't find one with a quick browse.

I am basically trying to do something like Text to Columns, but I am wanting to split the first and last text in a string. The first value is a date and the last value is a number ex: 17.54

I am copy/pasting bank statement transactions into a spreadsheet and want to easily separate the date and amount. I use text to columns for the date usually.

I attached a sample with what pastes into the spreadsheet, and what I want it to look like.

Thanks in advance!!!

Rox.

deleted------------

Thank you! I new it had to be something simple. I am sure I was overthinking it!!