Convert first 3 letters into desired one in the formula cell.

[PRADEEPB270]

Please look the below datas:-

CNDDRSSCRRBK CND
CNDKDRKCCRBRD CND
CNSKDRKSCRRBK CNS
PAPDRKCCRFBK PAP
PAPDRKCCRPMR PAP
PPOHDRKCCRSRD PPO
PPRHDRKSCRFBK PPR
SPSJDRSCCRBRD SPS
SPSJDRSCCRSBK SPS

I am applying the formula in cell B1, Left(A1,3) and result are CND.....SPS.But I want convert to PPO and PPR into PAP letters in the same column by formula i.e.B column.Is it possible?Please see the attach file for working and more clarification


Regards

Pradeep Kumar Gupta

[deadlyduck]

try this in cell D3:

Please Login or Register  to view this content.

[DonkeyOte]

similar to above but using inline array to shorten:

=IF(OR(LEFT(B3,3)={"PPO","PPR"}),"PAP",LEFT(B3,3))