#1
|
|||
|
|||
Import live data to a cell
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]? |
#2
|
|||
|
|||
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 |