Hello everybody
I have some data in Column H
Some data like that pattern
11 or 12 digits then a character then 11 or 12 digits![]()
Please Login or Register to view this content.
If this pattern existed then using udf or formula to add the following substring
which represents a character and 4 digits![]()
Please Login or Register to view this content.
The substring to be added after the first 11th or 12th digits and before the character existed
and the same substring to be added at the end
The result should be
Hope the example is clear![]()
Please Login or Register to view this content.
I will attach a sample
Bookmarks