two different formula need to join together

There's an old saying that goes...if it aint broke, dont fix it...if these 2 are working fine like they are - and are not causing any problems - why mess with them?

Having said that, if you are really insistent on combining them, what exactly are you trying to do with them?

H FDibbins , thanks for reply , here is my issue

My actual paragraph is like below in the cell A1 , here * means more sentence that I haven’t shown
**************million with consolidated sep of dd. 11.92 as of np. 524.19 million ************
From above paragraph I want to get only 11.92. for getting this particular value what I am doing ?

1st I delete all data that start form “as of np.” How I did ? its like below

Please Login or Register  to view this content.

So CELL B1 Results : **************million with consolidated sep of dd. 11.92

Here all data start form “as of np.” Has been removed
Now

Please Login or Register  to view this content.

CELL C1 Results : 11.92

Yes this the real output what I am looking for !!

Here cell C1 formula got form:

http://www.excelforum.com/excel-prog...ml#post3441876

if I raised whole project at time , I might not get the answer !! for this reason , I divided my problem into part by part . after getting all those then try to implement , hope you got my point.
ok no issue as

While I do understand your reason for splitting this, it would have been easier if you had put it all in the same thread

OK so all you really want out of a long string of text/numbers is the 11.92?

If so, then I would think you need to use the =mID() function...

=MID(A1,SEARCH("dd",A1,1)+4,(SEARCH("as of np",A1,1)-1)-(SEARCH("dd",A1,1)+4)

I presume that seeing as you marked this as SOLVED, you were satisfied wit my suggestion?

no problem, and thanks for the feedback