Coopergers
New Member
- Joined
- Jul 7, 2017
- Messages
- 1
Hi,
I am currently trying to pick out our order numbers beginning 'RVW0' from cells with long strings of text.
I have succeeded so far... however! Some idiot has been using underscores and now they're messing up my sheets! I need my formula to ignore everything either side of the order number as well as underscores now.
Please see my current formula and let me know how I can include the removal of underscores and words after it.
=TRIM(MID(SUBSTITUTE(Transactions!Q1," ",REPT(" ",99)),MAX(1,FIND("RVW0",SUBSTITUTE(Transactions!Q1," ",REPT(" ",99)))-50),99))
I'm giving myself a migraine trying to figure it out myself. But I know it won't be anything harder than the formula I currently have ?
Please help!
Joe Coops
I am currently trying to pick out our order numbers beginning 'RVW0' from cells with long strings of text.
I have succeeded so far... however! Some idiot has been using underscores and now they're messing up my sheets! I need my formula to ignore everything either side of the order number as well as underscores now.
Please see my current formula and let me know how I can include the removal of underscores and words after it.
=TRIM(MID(SUBSTITUTE(Transactions!Q1," ",REPT(" ",99)),MAX(1,FIND("RVW0",SUBSTITUTE(Transactions!Q1," ",REPT(" ",99)))-50),99))
I'm giving myself a migraine trying to figure it out myself. But I know it won't be anything harder than the formula I currently have ?
Please help!
Joe Coops
