I have the following data in a text column called [Workcenter]

1 SOCS

CSS

SCXP

SCQA

SCOO

SCPR

I need a formula which will create the following results

CC

CC

SCX

SCQ

SCO

SCP

I'm trying to combine these 2 working formulas

=IF([Workcenter]="1 SOCS","CC",IF([Workcenter]="CSS","CC"))

=LEFT([Workcenter],LEN([Workcenter])-1)

I tried this formula without success

=IF(Workcenter="1 SOCS","CC",IF(Workcenter="CSS","CC"(=LEFT([Workcenter],LEN([Workcenter])-1))))

Any ideas?