retricting web query results to number of characters...

  • Thread starter Thread starter J.W. Aldridge
  • Start date Start date
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?
 
I don't think so. But, you can import your data and then use a formula or
macro to get the left(yourcell,10)
 
Back
Top