Home > Software engineering >  How to extract after the specified string in the excel macro content
How to extract after the specified string in the excel macro content

Time:10-09

Changes in existing string "class name: 13 grade 9 class, the class number: A010201, class name: language result" the class name, class name is changing, character length is different also,
Now want to extract in the macro "class number:" seven characters, after the way, please?
It seems no macros in the find () function

CodePudding user response:

The debug. Print the split (split (" class name: 13 grade 9 class, the class number: A010201, class name: language result ", ", ") (1), ":") (1)

CodePudding user response:

Have to solve, thank you
  • Related