sksanjeev786
Well-known Member
- Joined
- Aug 5, 2020
- Messages
- 1,010
- Office Version
- 365
- 2016
- Platform
- Windows
Hi Team
I have a data in A to D and my output is F to I
i need p or q in center with out space refer example in F to I column
I have a data in A to D and my output is F to I
i need p or q in center with out space refer example in F to I column
book1 | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | |||
1 | 2 | 33.8 | 32 | 44 AB | 2 | 33.8 | 32 | 44 AB | |||||||
2 | 5 | 39.0 p | 36.5 p | 50.7 AB p | 5 | 39.0 p | 36.5 p | 50.7pAB | Need p or r in center but No space between letters | ||||||
3 | 51 | 16.9 p | 14.0 p | 22 b p | 51 | 16.9 p | 14.0 p | 22 p b | Rest is fine | ||||||
4 | 84 | 3.4 | 3.6 | 6.7 p | 84 | 3.4 | 3.6 | 6.7 p | |||||||
5 | 82 | 1.4 AC r | 1 | 5.3 r | 82 | 1.4rAC | 1 | 5.3 r | |||||||
6 | 20 | 44.9 B r | 34.2 p | 50 B p | 20 | 44.9rB | 34.2 p | 50pB | |||||||
Sheet1 |