Hi all, I need a new column in which I start from the ID but I need only one piece of this ID: I want only all values before “#”, like this in yellow column:
Some of these ID do not have the # so I can copy them without do anything more…
How can I do? I have tried the string manipulation but I cannot find a way…
Thanks
Giad