You show an example: "Spoon Soup Celine 18/0 Round 7 - 17.8Cm (502513) 12/1 Ea" where you want the "12/1 Ea" as result. The first / occurs before the values you want. Answer: Yes you are right, I apologize, the "/" can occur anytime, I just want the quantity. Your example does not have a consistent starting place as far as I can tell, or a consistent number of words at the end of the description. Answer: Yes you are right, it can be one word and it can be 2 words or even 3 words. I do understand that there is no set pattern, which makes it extremely difficult and I also understand I may not be able to get the desired result for all the rows. But anything to just get me started would be great. Also I had a slightly different request in another post,(How to split a character variable), where I only needed the description and not the quantity and one of the super users were able to get me started using the command below. This may be a silly question, but does the deleted characters get stored somewhere and if so, are we able to pull that info prxchange('s/\S+\s*(Ea|Ct|Kg|Gr|Lt|Lb|Ml)\b//i',-1,have); Thanks a lot
... View more