Removing default text from cells which are updatet with internet data

[Mystz0r]

Hi guys,

I've run into a major issue: I have a spreadsheet that updates stock prices and information, directly from a website. It correctly puts stock names in column A, stock ticker in B, bidding price in C, selling price in D, etc. When I update the sheet, it automatically corrects the value. So far so good.

My problem occurs in column A. Whilst also getting the name of the stock, it also get "STOCKMARKET BLABLABLABLABLABLABLA" before the stock name. Now, I want to create some sort of function that eliminates the text in front of the stock name, yet I don't want to break the auto data update from the external website.

Any ideas or am I not clear enough?

Thanks in advance,
Soren

 

[Mystz0r]

No ideas for this one?

 

[Mystz0r]