Kelli Webb
Member
Hi, HNY all,
I would like help to separate text that contains a "/" and put into a new column.
In column C I've used =TRIM(PROPER(IFERROR(RIGHT($A2,LEN($A2)-SEARCH("/",$A2,1)),""))) which seems to be working perfectly.
However, in Column B I would like to get everything to the left of the "/" or text without so every line in column B is populated
kind regards,
Kelli
I would like help to separate text that contains a "/" and put into a new column.
In column C I've used =TRIM(PROPER(IFERROR(RIGHT($A2,LEN($A2)-SEARCH("/",$A2,1)),""))) which seems to be working perfectly.
However, in Column B I would like to get everything to the left of the "/" or text without so every line in column B is populated
kind regards,
Kelli
Attachments
Last edited: