Extracting Specific Word From Extracted Innertext

Greetings!

I'm thinking how to extract specific word from extracted innertext and then put it in a cell.

the code I used to extract the innertext is,

Please Login or Register  to view this content.

Then the extracted innertext in ActiveCell.Offset(0, -1) is "1010058251/ esther mayormita benigno [0a003eda8287] Luid: 22"

I wanted a code that will extract the specific word "[0a003eda8287] Luid: 22", I don't know how to use Find in vba format, can anyone help me on this.

Nyahahahay, you're great nilem!

This is the code I used and is now working, thanks much nilem!

Please Login or Register  to view this content.

how about if the format of the string is like this?

Please Login or Register  to view this content.

then the value is like this.


"Current Results Stats for LUID: 18 Test Duration: 2 Pkt Length: 1522

Downlink Rate: 4739072 bps (4.74 Mbps)
Uplink Rate: 1285120 bps (1.29 Mbps)
Aggregate Rate: 6024192 bps (6.02 Mbps, 493 pps)
Pkt Xmt (Act/Exp): 778/0 (389 pps)
Pkt Rcv (Act/Exp): 209/0 (104 pps)

Downlink Efficiency: 100 Percent
Downlink Index (Act/Max): 100/100
Frag Count (Act/Exp): 18512/18512

Uplink Efficiency: 100 Percent
Uplink Index (Act/Max): 100/100
Frag Count (Act/Exp): 5020/5020


VC 34 Rate 1X/1X "


I wanted to extract the value "100 Percent" after the word "Downlink Efficiency" and "Uplink Efficiency", I used the code in this format

Please Login or Register  to view this content.

I added 11 in last part since "100 Percent" is 11 of length and the result is this "Downlink Ef", how should I revise the code so that instead of "Downlink Ef", I could extract the word "100 Percent"?

well then it works nilem! thank you very much!