Pulling the cost from a string of numbers and text into a new cell?

[markbrown]

I'm trying to extract the first cost in £ at the beginning of a cell that also contains a number of costs and some text into a new cell?

Example single cell contents below:
£1052.25: Mileage Cost £1000.25, Driver Dead Leg Pay, Driver Pay, Drop Charge, Toll/Carpark £52.00

I want to extract £1052.25 into a new cell any ideas please?

 

[cogswel__cogs]

There might be a way with trim but I will usually use a formula like this assuming cell with string is in A2
=MID(A2,1,FIND(":",A2,1)-1)
If the you would rather not have pound sign
=MID(A2,2,FIND(":",A2,1)-1) but keep in mind if there are values without sign it will cut off first number.

 

[markbrown]

There might be a way with trim but I will usually use a formula like this assuming cell with string is in A2
=MID(A2,1,FIND(":",A2,1)-1)
If the you would rather not have pound sign
=MID(A2,2,FIND(":",A2,1)-1) but keep in mind if there are values without sign it will cut off first number.

Perfect Thank you

 

[cogswel__cogs]

Glad it helped