Import live data to a cell

Crillezzz · #1 02-22-2019, 04:42 AM

I imported Live data into cell C10. But it's not pure tata. It says 59% are blblablababla. And I'm only interested in 59. I have moved numbers and text to different cells using text to columns. But every time the live data updates, numbers and text are put together again? Does anyone have an idea[ATTACH]

13401[/ATTACH]?

NoSparks · #2 02-22-2019, 09:18 AM

first two characters from the left
=LEFT(AG341,2)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Need to import group of cells using one cell	Madisont	Excel	0	05-26-2016 08:26 AM
Import some data to Word before run	KariiO	Word	2	04-02-2016 04:02 PM
Is there a method to import different data in one cell?	tesoke	Excel	12	03-08-2016 02:35 PM
I have a spreadsheet importing live data	SteveZ	Excel	1	11-06-2013 09:42 PM
Data query import	Gandalf	Excel	9	02-12-2013 03:03 AM