I have a value I take from the internet, specifically the market cap of some cryptocurriencies. I get these from the "get external data" function in excel. This loads the data in text format e.g. for a 1000 bitcoin value instead of getting 1000 i will get a cell that had 1000 BTC. Therefore, I am not able to use that data further. If I use the functions right, left, given that this value can fluctuate from 1000 to 1 or 1000000 the right and left will result in text format once the barrier is hit. On the other hand i cannot use the text to column separator as every time i refresh the table goes back to its original state and gets rid of any columns added by the user. Any suggestions to extrapolate the numbers from each cell dynamically are welcome. Thanks