Forum Discussion
Split Column - Delimiter Issue
Hello, I have a problem with splitting a column by delimiter. The values within the column look like this "ITEM01, ITEM02, " whih leads in this example to three columns (ITEM01, ITEM02 and an...
Is there any reason as to why you can not split on each occurance and then delete the final column?
Br,
J
Is there any reason as to why you can not split on each occurance and then delete the final column?
Br,
J
There are also cells without an item and therefore without a delimiter.
Is there a way to cut off the last two characters?
Then I could do this and then split as usual.