Hi All,
I was trying to clean the raw data and faced a situation which I need help.
Raw Data
abc 1
abcd 11
abc 22
abcde 14
The len is not constant.
How can I just get the data before the space using a formula.
So the result after the formulae would be:
abc
abcd
abc
abcde
I tried to use mid,left or right. I also give it a go with substitute formula but no luck. Maybe I am missing out something very simple ?
Please help me to slove this issue. Thanks for your time.
Regards,
Z.
I was trying to clean the raw data and faced a situation which I need help.
Raw Data
abc 1
abcd 11
abc 22
abcde 14
The len is not constant.
How can I just get the data before the space using a formula.
So the result after the formulae would be:
abc
abcd
abc
abcde
I tried to use mid,left or right. I also give it a go with substitute formula but no luck. Maybe I am missing out something very simple ?
Please help me to slove this issue. Thanks for your time.
Regards,
Z.