Looking at this data I see 2 ways to pull it off. As far as a formula goes to extract out the number in quotes I think it would be much easier to write that part in VBA. The other thing you can do without the use of VBA is to use the Text to Columns. Use the " as the delimiter and it will separate those number automatically. Then you can run all the formulas you want to grab the data which would be pretty easy at that point.