Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[darichman]

I'm trying to use excel to build a handover sheet for the special care nursery I work in.

Quick question to anyone who might know...

If I have a cell containing gestational age in the format 32+5
  is there any way to extract the '32' and the '5' as two separate things for reference in other cells? I'd like to do this without needing two separate cells.

For a bit of background, I'm trying to have excel automatically calculate the age of the baby in days and the corrected gestational age (=age in days + gestational age)

Thanks in advance.

[mykillk]

LEFT( CELL, 2 ) <--- grab that 32
RIGHT( CELL, 1 ) <---- grab that 5

The 2 and 1 being the number of characters/digits you want to grab. So it would only work if your numbers will have the same number of digits. If not, use zero padding.

[darichman]

Excellent. Works perfectly - thanks mykillk!

[darichman]

New question - how can I pick the '2' in q2h?
q1h = 1
q2h = 2
q3h = 3 etc?

Thanks again!

[fridden]

New question - how can I pick the '2' in q2h?

if the number is always in the 2nd position you can use =MID(cell,character-posotion,length)

So if q1h is in A1 you can say
=MID(A1,2,1)

/fridden