I have a file where I need to extract all the text before a delimiter which in this case is "/" into a cell and then also all the text after the "/" into a different cell.
I've managed to get the first command working but can't get the second task for the other cell working.
For the first one I've used:
Code: Select all
=LEFT(TRIM(Products.D2);FIND("/";TRIM(Products.D2))-1)
Code: Select all
RIGHT
I'm pulling the data from a different file, which would be cell
Code: Select all
Products.D2
Example Data:
Thank you for any help in advance!Temperature Displaying Smart Ring / Silver – 9