How I get closing price from cell?

[HerryMarkowitz]

Greetings,

A1 cell includes;
Dividend Payment : TWITTER (National Market) %39,06 (Closing Price: 5,28 Dolar), Cash Dividend
I want 5,28 result in B1 cell ?

A2 cell includes;
Dividend Payment : FACEBOOK %5,00 (Closing Price: 53,18 Dolar), Stock Dividend
I want 53,18 result in B2 cell ?

In order to understand my question open enclosed file.

Thanks in advance.

Note1: "Closing Price:" text in the cells are stable.
Note2: "Dolar" text in the cells are stable.

[oeldere]

With 2 helpcolumns (see the attached file).

c1=

Please Login or Register  to view this content.

I don't know the translation of vind.spec. (dutch) for the helpcells so please see for that forumula the excel file.

[Punnam]

Hi,

Find the attached .
Is this what u r looking for ?
Punnam

[HerryMarkowitz]

Hi oeldere,
Is it possible to take formulas from D and E columns to C column?
I mean I need one formula not three?

Hi Punnam,
Thanks for your support, but your result are "text", I prefer "value" as oeldere example.

[martindwilson]

HMz
just add 0 to the formula in post #3 to get a value
=SUBSTITUTE((TRIM(MID(A1,(SEARCH("Closing Price:",A1)+1+14),(SEARCH("Dolar",A1)-1-SEARCH("Closing Price:",A1)-14)))),",",".")+0

[HerryMarkowitz]

Thanks everybody.

[oeldere]

See the changed formula in the attached file (without helpcells)

[Punnam]

Hi,

Check the updated file which will match u r requirement.

Punnam