retricting web query results to number of characters...

J

J.W. Aldridge

I have a web query that pulls a large string of data.
Is there any way that I can adjust my query to only pull the first 10
characters (left) of the table?
 
D

Don Guillett

I don't think so. But, you can import your data and then use a formula or
macro to get the left(yourcell,10)
 
Top