Need help parsing lab data from a snip to Excel data elements for graphing purposes

Copper Contributor

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 separate cells.

 

Lab dataLab data

 

Thanks for any and all suggestions.

 
 
1 Reply

@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,