sksanjeev786
Well-known Member
- Joined
- Aug 5, 2020
- Messages
- 1,010
- Office Version
- 365
- 2016
- Platform
- Windows
Hi Team
I have data in Column A and B and output coming in Column G but I need data as per column I like I10, I13 and I16 cells like where ever I have data wiht numbers and letter I need p and r should come in the center please ref yellow highlighted
I have data in Column A and B and output coming in Column G but I need data as per column I like I10, I13 and I16 cells like where ever I have data wiht numbers and letter I need p and r should come in the center please ref yellow highlighted
book2 | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | |||
1 | But I need as | ||||||||||
2 | 9.1 | 27.6 | p | 9.1 | 27.6 p | 27.6 p | |||||
3 | 14.3 | 33.8 | p | 14.3 | 33.8 p | 33.8 p | |||||
4 | 93.5 | 4 | 93.5 | 4.0 | 4.0 | ||||||
5 | 51.9 | 17.7 | 51.9 | 17.7 | 17.7 | ||||||
6 | 61 | 22.5 | p | 61.0 | 22.5 p | 22.5 p | |||||
7 | 90.9 | 2.8 | 90.9 | 2.8 | 2.8 | ||||||
8 | 89.6 | 2.8 | 89.6 | 2.8 | 2.8 | ||||||
9 | 68.8 | 10.9 | 68.8 | 10.9 | 10.9 | ||||||
10 | 32.5 | 34.6 AC | p | 32.5 | 34.6 AC p | 34.6 p AC | |||||
11 | 76.6 | 1.9 | 76.6 | 1.9 | 1.9 | ||||||
12 | 70.1 | 10.9 | 70.1 | 10.9 | 10.9 | ||||||
13 | 80.5 | 10.6 A | p | 80.5 | 10.6 A p | 10.6 p A | |||||
14 | 88.3 | 5.4 C | 88.3 | 5.4 C | 5.4 C | ||||||
15 | 87 | 2.9 | 87.0 | 2.9 | 2.9 | ||||||
16 | 87 | 6.7 AC | p | 87.0 | 6.7 AC p | 6.7 p AB | |||||
17 | 88.3 | 5.4 A | 88.3 | 5.4 A | 5.4 A | ||||||
18 | 89.6 | 6.6 | 89.6 | 6.6 | 6.6 | ||||||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
F2:F18 | F2 | =A2 |
G2:G18 | G2 | =TEXT(B2,"0.0")&" "&D2 |