IF + Text.Start issue

[Cime14]

Hi,
can anyone help me with the below formula? I have in Profit Center column fields: HR01/110022 and 110055 and I would like to get only 11 in the new column. HR01 can change to multiple options so I tried to use Text.Start after "/" but formula doesn't work....

=if Text.Start([Profit Center],5) = "/" then Text.Middle([Profit Center],5,2) else Text.Start([Profit Center],2)

Thanks!

 

[RoryA]

Try:

= if Text.Middle([Profit Center],4, 1) = "/" then Text.Middle([Profit Center],5,2) else Text.Start([Profit Center],2)