two different formula need to join together

[nur2544]

Dear all, two different formula need to join together
1st formula

LEFT(B1,FIND("as of np",B1)-1)

2nd formula

IF(ISNUMBER(SEARCH("sep of dd.",B1)),MID(B1,SEARCH("sep of dd.",B1)+11,LEN(B1)))

currently i kept above two formula in different two cell to get actual output. now i want to keep both formula in a single cell

[FDibbins]

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?

[nur2544]

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

CELL  B1:  LEFT(A1,FIND("as of np",A1)-1)

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

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

CELL C1: IF(ISNUMBER(SEARCH("sep of dd.",B1)),MID(B1,SEARCH("sep of dd.",B1)+11,LEN(B1)))

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

[FDibbins]

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)

[FDibbins]

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

[nur2544]

Hi FDibbins, it works very well , happy to get very small formula for the complex task .

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

I marked this as SOLVED because , I thought it is complex issue & although my particular job already solved by two formula so I should not kill others valuable time for the same issue .

[FDibbins]

no problem, and thanks for the feedback