I building a sheet where I track BP data. I have the raw data in a standardized text format:
tttt: Sys/Dia/HR: optional notes
I'm trying to extract various parameters (Systolic, Diastolic, Heart rate) from said data into adjoining cells (don't care about the notes). I've had limited success with the first after hacking together formulas, but testing has encountered errors. For systolic, I've managed to get this far with data in A2:
=MID(A2, SEARCH(": ", A2) + 2, SEARCH("/", A2, SEARCH("/", A2) + 1) - SEARCH("/", A2))
I'm attaching a demo file. Any help would be appreciated.
-- Bad Idea Fairy
Bookmarks