Dear forum,
I have cells that includes text, numbers etc and I need to extract the text into a new cell (kind of cleanup)
It looks like this:
1: Light Yellow: 1,00, 8: Dark Green: 1,00, 12: Light Blue: 2,00
item number: item name: amount with decimal,
What I need is to extract the item name with a " + " as a separator if there is more items in the cell.
So for this example it would be:
Light Yellow + Dark Green + Light Blue
Sample file attached
Thanks
Bookmarks