Capture Weird data from a cell

ctackett6407

Board Regular
Joined
Mar 18, 2018
Messages
64
Hey Folks!

I'm trying to figure out how to capture specific locations in a cell.
Basically below is a column from a report I pull. My boss would like me to be able to pull out the speedtest download and upload and show it in a report with the areas that are associated with those speeds and possibly average them.

Is this even possible?

<tbody>
</tbody>

<tbody>
</tbody>
["Speedtest Download", "Speedtest Upload", "Speedtest Latency", "Speedtest Jitter", "Speedtest Host", "Speedtest At Address"]
["", "", "", "", "", ""]
[0.13, 0.22, 300, 0, nil, true]
[0.0, 0.0, 0, 0, "", true]

<tbody>
</tbody>
 

Some videos you may like

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

jjasmith4

New Member
Joined
Aug 22, 2018
Messages
48
Import the report as delimited text, then your download will be in A, and the upload in B.
 

Watch MrExcel Video

Forum statistics

Threads
1,113,903
Messages
5,544,959
Members
410,643
Latest member
sng
Top