Forum Discussion
Solved
FIND AND COPY
I have a huge spreadsheet with lots of pack of qty entries in the description column. How do I set about copying the qty into a separate column on the spreadsheet?
- Just tested your formula on the entire spreadsheet.
AMAZING! It works a treat.
Does exactly what I wanted.
Thank you so much for your help.
Overnight it occurred to me that this use of UPPER would resolve the issue of upper or lower case references to "pack of"...it will even work with "pAcK oF"
=IFERROR(VALUE(RIGHT(B4,LEN(B4)-FIND("PACK OF",UPPER(B4))-7)),1)
By the way, I hope you are changing the procedure by which this information is collected (assuming it's an ongoing process) so that you head off these semi-useless entries before they occur.
Just tested your formula on the entire spreadsheet.
AMAZING! It works a treat.
Does exactly what I wanted.
Thank you so much for your help.
AMAZING! It works a treat.
Does exactly what I wanted.
Thank you so much for your help.