Hi thanks for your great help to explain.Your explaination(Find,Left and Mid) is very clear and logical.step by step. it is easyier to understand

But in my data, maybe it involved many spaces between the data, so i
cannot work out the answer. i really need your great help.

Thanks for your great help
Tom