Need to add bulk rows and text moved into new rows

[abbas99]

Hi Excel Experts,

I have a excel sheet with about 8000 Rows. It has 5 Columns. Screenshot below:





What I want them to be looked like:

And I have this "was" price in some of columns. I want to have only the New price. For Example:
[TABLE="width: 164"]
<tbody>[TR]
[TD="width: 164"]
"Was £387.25 £375.42"

I just want "3.75.43" and rest removed.[/TD]
[/TR]
</tbody>[/TABLE]


Is there a way to do this? With VBA or any formula? Any Help would be very appreciated.