madhuchelliah
Board Regular
- Joined
- Nov 22, 2017
- Messages
- 226
- Office Version
- 2019
- Platform
- Windows
Hello all, i have a string in D4. Length of the string is dynamic. Within the string, alpha character will be always single character (A to Z) or double character(AA to ZZ). I want to find the single character alpha within the string and insert the alpha character given in the cell C4. Leave the double alpha character as it is. Please see the example below for clarity. Thank you.
Book1 | ||||
---|---|---|---|---|
C | D | |||
4 | A | 2154-255 254B, 5545E, D454-D444 258BA454 | ||
5 | 2154-255 254AB, 5545AE, AD454-AD444 258BA455 | |||
Sheet2 |