Home > Software engineering >  Excel macro about string extraction
Excel macro about string extraction

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
  •  Tags:  
  • VBA
  • Related