I need to extract texts between [] in a string and save in a array:
For example: MyStr = "This is [name] and [number]"
Result array: MyArray = ["name","number"]
Any idea how to to this with vba?
Thanks!
For example: MyStr = "This is [name] and [number]"
Result array: MyArray = ["name","number"]
Any idea how to to this with vba?
Thanks!