opposite of concatenate

  1. R

    Sort of like opposite of concatenate

    My data looks like this: Cell A9 - Backplate 1-2 weeks 14 Cell A10 - Carbon Wall Mounts 1-2 weeks 14 Cell A11 - AP Mount 1-2 weeks 14 Cell A12 - AP Power Pack Mount 1-2 weeks 14 I want to do some kind of text to columns or formula or something that will leave me with: Cell A9...

Some videos you may like

This Week's Hot Topics