madhuchelliah
Board Regular
- Joined
- Nov 22, 2017
- Messages
- 226
- Office Version
- 2019
- Platform
- Windows
Hello All, i have sentence in D column and range is dynamic, it is mixed of alphanumeric. I need a VBA to look into the words with 7 characters, copy the first character of the word and insert as fifth character. This makes all the 7 character words into 8 character words in the sentence.
Example: Q374 WE333RE333 N123154 QW258 A878968. Expected output is Q374 WE333RE333 N123N154 QW258 A878A968.
Thank you.
Example: Q374 WE333RE333 N123154 QW258 A878968. Expected output is Q374 WE333RE333 N123N154 QW258 A878A968.
Thank you.