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.
Last edited by HerryMarkowitz; 08-02-2014 at 06:07 AM.
Sub DontForgetThese() If Your thread includes any code Then Please use code tags... If Your thread has been solved Then Please mark as solved... If Anybody has helped to you Then Please add reputation... End Sub
With 2 helpcolumns (see the attached file).
c1=I don't know the translation of vind.spec. (dutch) for the helpcells so please see for that forumula the excel file.=Right(Left(A1,E1),E1-D1)*1
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Hi,
Find the attached .
Is this what u r looking for ?
Punnam
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.
Last edited by HerryMarkowitz; 08-02-2014 at 06:42 AM.
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
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Thanks everybody.
See the changed formula in the attached file (without helpcells)
Hi,
Check the updated file which will match u r requirement.
Punnam
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks