I'm trying to process data in CSV format using Excel.
I can import the CSV file, but I need to process this data in various ways. For example, I have a coloumn of hex values that need to be plotted. So I need to convert all the rows in this column to decimal numbers.
The imported CSV is in an Excel table, and I have tried using the typical =HEX2DEC('Data'!$A2:A)
, but it doesn't work at all.
The file I am processing has varying length. Some files are 20 rows long, others are 600,000. Obviously I don't want to copy-paste even 20 lines, let alone 600K lines.
I am required to use excel for this and I don't have VBA access. Is what I am trying to do even possible?
Edit 0:
Here is the section of the data that I am trying to use HEX2DEC
on
data table 1 This is A and B coloumn. B1 has some headers in it that I don't care about right now. This will sometimes be from B2 to B500, or B2 to B5. These are all on Sheet1
(Which I have named Data
).
I can perform HEX2DEC
on one cell, Sheet 2 formula. But even double clicking on the green corner on the bottom right will not extend it down to match the size of the data on Sheet1
. It would also be nice if there was a way to automate that such that I can just import the CSV data to Sheet1
and have Sheet2
automatically update the fields and adjust to the size of the data imported.