sksanjeev786
Well-known Member
- Joined
- Aug 5, 2020
- Messages
- 883
- Office Version
- 365
- 2016
- Platform
- Windows
Hi Team,
I want to change the letter as per requirement.
IF column as H,I,J,K,L i want to those change to ABCDE
so example 16% will be 16%A, 25%K will be 25%D and 30%MN should be only 30%
can anyone help me on this also need formula to let (H) to H only
I want to change the letter as per requirement.
IF column as H,I,J,K,L i want to those change to ABCDE
so example 16% will be 16%A, 25%K will be 25%D and 30%MN should be only 30%
can anyone help me on this also need formula to let (H) to H only
book2 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | PCP - Wave 1 (H) | PCP - Wave 2 (I) | PCP - Wave 3 (J) | PCP - Wave 4 (K) | ||
2 | H | I | J | K | ||
3 | A | B | C | D | ||
4 | 23% | 16%H | 16%H | 30%MN | ||
5 | 17%I | 25%K | 17% | 16% | ||
6 | 44% | 41% | 46% | 42%J | ||
7 | 15% | 17% | 21% | 1% | ||
Sheet1 |