asked on # Excel formulas for extract (VBA)

Hi

I need excel formula or VBA.

I need extract between "MeContext=" and "," result should be in B1=CLWRFLSRBBU04124

and same need to be extract between "EFDD=" and "," result should be in C1=CLWRFLSRBB434411

A1=Frame=r,SubNetwork=Tam,MeContext=CLWRFLSRBBU04124,ME=1,EF=1,EFDD=CLWRFLSRBB434411,ER=8565

B1 = CLWRFLSRBBU04124

C1 = CLWRFLSRBB434411

I need excel formula or VBA.

I need extract between "MeContext=" and "," result should be in B1=CLWRFLSRBBU04124

and same need to be extract between "EFDD=" and "," result should be in C1=CLWRFLSRBB434411

A1=Frame=r,SubNetwork=Tam,

B1 = CLWRFLSRBBU04124

C1 = CLWRFLSRBB434411

Microsoft OfficeVBAMicrosoft ExcelMicrosoft ApplicationsSpreadsheets

Hi Shums,

Thanks you for your contribution, but in formula comma (,) only is constant in position of ",ME=" and ",ER=" , So ME= & ER= will be variable one.

So is possible to extract between "MeContext=" and "," only?

Thanks you for your contribution, but in formula comma (,) only is constant in position of ",ME=" and ",ER=" , So ME= & ER= will be variable one.

So is possible to extract between "MeContext=" and "," only?

Hi Vijay,

You can extract 16 digit number after "MeContext=" with below formula:

Extract-Text-Between-Two-Text_v2.xlsx

You can extract 16 digit number after "MeContext=" with below formula:

```
=MID($A1,SEARCH("MeContext=",$A1)+10,16)
```

And 16 digit number after "EFDD=" with below formula:```
=MID($A1,SEARCH("EFDD=",$A1)+5,16)
```

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

Try below in B1:

Open in new window

And below in C1:Open in new window