Work with the example
How do you separate the name from a description that contains another slash? The supplied label is Desk / revised / October. Keep A5 unchanged and calculate the first delimiter position in B5. The delimiter is exactly space/slash/space.
| Position | Name | Description |
|---|---|---|
| 5 | Desk | revised / October |
Edit the working cells
B5 uses =IFERROR(FIND(" / ";A5);0). C5 reads LEFT(A5;B5-1); D5 reads MID(A5;B5+3;LEN(A5)), with both guarded for B5=0. Change A5 to Field / November: the two outputs become Field and November. Desk/October has no stated delimiter, so the name says Separator missing and the description stays empty.
Check the failure case
Splitting every slash would turn the original into three fields. This exercise wants two, and deliberately retains revised / October together. It does not decode backslash escapes or arbitrary list syntax.
What does B5=0 mean here?
Show the worked answer
The exact delimiter was absent, not that the name has zero characters.