Formula req

[vvinod]

Trans_id:1639660935, Item:320781002202- PROD, Org:180, Batch:242665, Status:CLOSED, Terminated(Y/N):N, Trans.Qty: 90 CTN


from this i want to take output as 320781002202, can you give formula

 

[JEC]

Always after Item: and before - ?

 

[vvinod]

Yes always after Item:

 

[Joe4]

It is hard to detect patterns from just a single example.
Is the entry always exactly 12 characters long?
If so, you could use this formula (for an entry in cell A1):

=MID(A1,FIND("Item:",A1)+5,12)

If the values you are trying to pull are not always 12 characters long, then we will need to know more details, such as does "- PROD" appear after every number you are pulling?
If not, please post a number of examples, showing the different structure you may have and what you want in each case.

 

[Peter_SSs]

If the value of interest is not always 12 characters but is between "Item:" and the following "-" then you could try

=REPLACE(LEFT(A1,FIND("-",A1,FIND("Item:",A1))-1),1,FIND("Item:",A1)+4,"")

 

[kvsrinivasamurthy]

Try. A2= text

=LEFT(MID(A2,FIND("Item:",A2)+5,LEN(A2)),FIND("-",MID(A2,FIND("Item:",A2)+5,LEN(A2)))-1)