Hi,

Use this to sum the numbers

=SUMPRODUCT(--(TRIM(LEFT(A1:A4,FIND(" ",A1:A4)))))

to extract the letters

=TRIM(MID(A1,FIND(" ",A1),LEN(A1)))

drag down

Mike

" wrote:

I would like to have my spreadsheet have number of hours for a shift, but
also identify which shift it is, for example:
11 ICU
10 CL
8 E
10.5 N

I need to be able to sum the hours, but also identify who is working what.
Help.