Excel small white, could you tell me how to do this coming?

CodePudding user response:

Three positions, the first is the longest points out, and then went to the office to get the unit from the inside, such as D2 formula can be:
=the IF (RIGHT (B2, 5)=", deputy director of the clerk, "deputy director of the clerk," IF (RIGHT (B2, 4)="section head," chief "clerk", the IF (RIGHT (B2, 2)="clerk", "senior staff", "?????? ")))
C2: (perfect you can distinguish whether D2 under normal)
=LEFT (B2, LEN (B2) - LEN (D2))

CodePudding user response:

Very good

CodePudding user response:

You can also set drop-down menu, choose their own,