This is a one line code snippet to extract any section of a string using the Split() function. You can actually return the indexed section right in the same line as the Split() without having to assign the Split() to an array.
Original Author: Rocky Clark (Kath-Rock Software)
Code
Place this line in your immediate window and run it. It will return "Test5".
Print Split("Test0 Test1 Test2 Test3 Test4 Test5 Test6", " ")(5)