I have a a column of information that includes the following:
C110904-2.25-O110504

I need to sort on only the [C110904]. The [C] indicates CLOSED and will
always be there plus the 110904 is a date and it also is always in that
format. I would appreciate any help.

Thanks in advance!