- Messages
- 58
- Reaction score
- 0
- Points
- 26
Re: MS excel formula, programming, analysis, presentation and tutorials.
Boss pahelp naman sa problem ko.
Pano ko po makukuha ang specific word sa mahabang link na to. I'll try left and find pero di ako magkaigi hehe.. possible po kasi n yang value ng example na yan hindi laging 10 characters.
For example ang kukunin ko is ito: B01DKGO9NY
https://www.amazon.com/LP-Silicone-...s-min-purchase-required:5016683011,p_36:-3900
ito po formula ko
=IFERROR(LEFT($A2,FIND("/",$A2,1+FIND("/",$A2,1+FIND("/",$A2,1+FIND("/",$A2,1+FIND("/",$A2,1+FIND("/",$A2))))))-1),"") - ang nakuha ko dito is ito lang
https://www.amazon.com/LP-Silicone-Resistant-Potholder-Fireplace/dp/B01DKGO9NY
=IFERROR(RIGHT($R2,10),"") - then saka ko ginamitan nito para makuha ko yung B01DKGO9NY
meron pa po bang ibang way kasi nga hindi laging 10 characters yun.
Thanks in advance sa sasagot.
Boss pahelp naman sa problem ko.
Pano ko po makukuha ang specific word sa mahabang link na to. I'll try left and find pero di ako magkaigi hehe.. possible po kasi n yang value ng example na yan hindi laging 10 characters.
For example ang kukunin ko is ito: B01DKGO9NY
https://www.amazon.com/LP-Silicone-...s-min-purchase-required:5016683011,p_36:-3900
ito po formula ko
=IFERROR(LEFT($A2,FIND("/",$A2,1+FIND("/",$A2,1+FIND("/",$A2,1+FIND("/",$A2,1+FIND("/",$A2,1+FIND("/",$A2))))))-1),"") - ang nakuha ko dito is ito lang
https://www.amazon.com/LP-Silicone-Resistant-Potholder-Fireplace/dp/B01DKGO9NY
=IFERROR(RIGHT($R2,10),"") - then saka ko ginamitan nito para makuha ko yung B01DKGO9NY
meron pa po bang ibang way kasi nga hindi laging 10 characters yun.
Thanks in advance sa sasagot.