Hello I've been trying to clean some data in cells and format the strings in a specific way e.g.
Input:
abcdef1234ghij5678klmn
Required format of string:
Part-1234, Section-5678
The sequence of letters preceding, in between and following the numeric digits can be of variable length and may include alphabets, spaces, hyphens, commas, periods and slashes ( "/" or "\" )
I'm just quite a novice in VBA programming I just don't know enough of it to get my head around this problem.
Thank you for any help and guidance towards solving this.
Input:
abcdef1234ghij5678klmn
Required format of string:
Part-1234, Section-5678
The sequence of letters preceding, in between and following the numeric digits can be of variable length and may include alphabets, spaces, hyphens, commas, periods and slashes ( "/" or "\" )
I'm just quite a novice in VBA programming I just don't know enough of it to get my head around this problem.
Thank you for any help and guidance towards solving this.