I have text which is imported into a spreadsheet.

All the text is in an individual cell but within that text will be a value
that i want to capture.

for examle

"the selling price for this is £2.99 and the product code is 123456"

i have similar text going down in column A for about 120 rows?

the value i want is the price being £2.99, i can't use the left, right or
mid function as the length of the text can be any length.

Is there another function i can use that can pick up this value?

i'm trying to write a macro that will pick up this value and use it for
further calulations.

Next question

If i want a macro to stop running and close excel completely without saving
the spreadsheet what is the code for this?

for example

if activecell.value = "" then
close excel??

thank you in advance

hervinder