Home

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

%3CLINGO-SUB%20id%3D%22lingo-sub-879621%22%20slang%3D%22en-US%22%3ENeed%20help%20parsing%20lab%20data%20from%20a%20snip%20to%20Excel%20data%20elements%20for%20graphing%20purposes%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-879621%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20take%20lab%20data%20from%20a%20health%20record%20snip%20and%20covert%20it%20to%20data%20elements%20in%20Excel.%20Hitting%20a%20roadblock.%20Help%20is%20much%20appreciated.%20Here%20is%20an%20example%20of%20the%20snip.%20Need%20dates%20and%20data%20in%20separate%20cells.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20691px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F133786i5242C170C9D8A997%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22snip.PNG%22%20title%3D%22snip.PNG%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3ELab%20data%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20any%20and%20all%20suggestions.%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-879621%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-887535%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20help%20parsing%20lab%20data%20from%20a%20snip%20to%20Excel%20data%20elements%20for%20graphing%20purposes%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-887535%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F242657%22%20target%3D%22_blank%22%3E%40Walter%20Bender%3C%2FA%3E%26nbsp%3BWhen%20you%20say%20%22snip%22%20do%20you%20mean%20a%20static%20screen%20shot%3F%20If%20that's%20the%20case%2C%20then%20I%20don't%20think%20there's%20much%20you%20can%20do.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20the%20data%20is%20actually%20in%20Excel%2C%20and%20you're%20trying%20to%20parse%20values%20out%20of%20the%20cells%2C%20then%20you%20can%20use%20a%20formula%20like%20this%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DIFERROR(--LEFT(A1%2CFIND(%22%20%22%2CA1)-1)%2CA1)%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20the%20cell%20has%20a%20space%20%26amp%3B%20character%20in%20it%2C%20then%20this%20will%20strip%20the%20H%20out%2C%20and%20convert%20it%20to%20a%20value.%20If%20it's%20a%20value%2C%20then%20it%20will%20treat%20it%20like%20a%20value.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFor%20the%20date%20row%2C%20just%20format%20it%20as%20mm%2Fdd%2Fyy%2C%20and%20you%20won't%20see%20the%20hours.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHTH%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Walter Bender
Occasional Visitor

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.

 

snip.PNGLab 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,

 

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies