Hello,
I am fairly new with VBA and code has never been my strongpoint. I do research in a Nueroimmune Lab and I am working on a series of macros for exporting/manipulating large data sets from out flow cytometry individual panel reports (.xls) into one master worksheet. I have managed to accurately pool data into one workbook, but would like to change the notation on a specific column of data. The column reports cell concentration:
[TABLE="width: 0"]
<tbody>[TR]
[TD]6.7x10^3/uL
[/TD]
[/TR]
</tbody>[/TABLE]
I would like to be able to only keep the first 3 characters of the cell in string and loop through each cell saving these new values as a string. Any help would be greatly appreciated!
-Jared
I am fairly new with VBA and code has never been my strongpoint. I do research in a Nueroimmune Lab and I am working on a series of macros for exporting/manipulating large data sets from out flow cytometry individual panel reports (.xls) into one master worksheet. I have managed to accurately pool data into one workbook, but would like to change the notation on a specific column of data. The column reports cell concentration:
[TABLE="width: 0"]
<tbody>[TR]
[TD]6.7x10^3/uL
[/TD]
[/TR]
</tbody>[/TABLE]
I would like to be able to only keep the first 3 characters of the cell in string and loop through each cell saving these new values as a string. Any help would be greatly appreciated!
-Jared