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
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies