Guanjin Peter
Active Member
- Joined
- May 21, 2008
- Messages
- 429
i did a search at the forum, I found that you are able to search for certain crtira for words. But what if it's random like above?
It'll search for the 2nd and the 3rd letter, and return the 2nd and 3rd letter. The 2nd part I dunno if it's possible, i'll leave it as an seperate question. Would prefer formula rather than vba code(so that it's easier to copy down)
RPM - 100
MRM - 110
VFG - 110
VRM - 100
Return value:
PM
RM
FG
RM
the 2nd part is the tricky part
RPM - 100
MRM - 110
VFG - 110
VRM - 100
NUH - 150
Return value:
PM
RM
FG
RM
NUH
It'll search for the 2nd and the 3rd letter, and return the 2nd and 3rd letter. The 2nd part I dunno if it's possible, i'll leave it as an seperate question. Would prefer formula rather than vba code(so that it's easier to copy down)
RPM - 100
MRM - 110
VFG - 110
VRM - 100
Return value:
PM
RM
FG
RM
the 2nd part is the tricky part
RPM - 100
MRM - 110
VFG - 110
VRM - 100
NUH - 150
Return value:
PM
RM
FG
RM
NUH