I have the following data in a text column called [Workcenter]
1 SOCS
CSS
SCXP
SCQA
SCOO
SCPR
1 SOCS
CSS
SCXP
SCQA
SCOO
SCPR
I need a formula which will create the following results
CC
CC
SCX
SCQ
SCO
SCP
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)
=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))))
=IF(Workcenter="1 SOCS","CC",IF(Workcenter="CSS","CC"(=LEFT([Workcenter],LEN([Workcenter])-1))))
Any ideas?
