Im surprised this hasnt been answered yet. Yes this is possible to do. The only clarification needed is when you say the word chain do you mean literally the word chain or a text string you can change as needed. This would be completed with a simple loop however it appears that your data has been copied and pasted from somewhere else hence all of the white space between fields ( This can be removed using the function "trim") so with that we would also need to know if the data you paste in will keep getting bigger or if it is just this set of data so we know where to cut the loop off.
Again yes this is possible
|