Feb 16, 2023
I have a column 'Original' with the value: Breakfast-NO|Lunch-YES|Dinner-YES
I want to the next three columns that are set to formula to automatically be set like this:
Breakfast would be the string between the first '-' and '|'Lunch would be the string between the second '-' and '|'Dinner would be the string between the third '-' and '|'
also want to convert the value from No to FALSE, YES to True
Go to Solution.
Feb 17, 2023
See Solution in Thread