Posted to microsoft.public.excel.querydao,microsoft.public.excel.programming

Don Guillett Don Guillett is offline

external usenet poster

Posts: 10,124

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
replace a negative result with a zero?	Pam2277	Excel Discussion (Misc queries)	2	April 19th 10 05:33 PM
How to replace formula with its result	jclown	Excel Worksheet Functions	2	March 17th 10 09:59 AM
Replace ^ in web query result	Don Guillett	Excel Worksheet Functions	0	April 26th 06 03:42 PM
Importing result from Access query to Excel but the result only c.	Edwin	Excel Discussion (Misc queries)	0	March 16th 06 01:36 AM
Replace with result of database query, instead of inserting	Android[_2_]	Excel Programming	2	May 12th 04 04:38 PM

All times are GMT +1. The time now is 09:35 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us