Perform search & return complete text out of a range but not the full cell content

Do you mean a single word?

If you don't how would you determine what part of the text to take from the cell?

If you look at the array "keyword"; it holds 4 prefixes; the If statement is a value from a textbox that is the designated target. For instance if the entered part matches column A2, then it will move over to V2 and start looking for the prefix value in the array. The reason these are prefixes is because they can be different numbers but will always start with those prefixes; I want to be able to extract the rest of those numbers and populate them in the listbox.

I need help in determining how can the rest of the word can be extracted; could be something like instr(Range("V" & i).value, letterHolder + 1, " ") stating that it will stop when a 'space' is found. I'm just not sure how that can be achieved by getting those letters together to form the word/text.