Our website has pricing tables per product that appear like this:





In order to update pricing on our website, we have to use an import/export text file that is in this format with a lot of extra characters that make it tedious to edit; this data is all in one cell when opened in Excel:



(Hopefully the image above can be clicked on to enlarge.)

We use this simple pricing spreadsheet to calculate our prices:



For instance, we want the '15.51' in the long string to be replaced with '16.95', etc.

Any suggestions on a way to update the import/export text file with the new values from our pricing spreadsheet?

Thanks for giving it any thought,

John