ExcelBanter - Replace ^ in web query result

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Replace ^ in web query result (https://www.excelbanter.com/excel-programming/359827-replace-%5E-web-query-result.html)

Don Guillett

Replace ^ in web query result

I can't remember how to fix this. I am running a web query macro in xl2002.
When I run in xl97 I get a caret ^ at the beginning of each cell.
^$.77

Sorry about multipost but few look at querydao
TIA

--
Don Guillett
SalesAid Software

All times are GMT +1. The time now is 05:16 PM.