Forum Discussion
Need help parsing lab data from a snip to Excel data elements for graphing purposes
I am trying to take lab data from a health record snip and covert it to data elements in Excel. Hitting a roadblock. Help is much appreciated. Here is an example of the snip. Need dates and data in s...
Walter Bender When you say "snip" do you mean a static screen shot? If that's the case, then I don't think there's much you can do.
If the data is actually in Excel, and you're trying to parse values out of the cells, then you can use a formula like this:
=IFERROR(--LEFT(A1,FIND(" ",A1)-1),A1)
If the cell has a space & character in it, then this will strip the H out, and convert it to a value. If it's a value, then it will treat it like a value.
For the date row, just format it as mm/dd/yy, and you won't see the hours.
HTH,