0

I'm trying to split cells with multiple forward slashes in between words. Some have 5, some have 7, some have 8.

Text to Columns doesn't work correctly, and my subscription doesn't have TEXTSPLIT.

I've tried using the above method but to no avail. Can I use an IF instead?

Carl Stevens
  • 1
  • 1
    FIND() can be used to find the position of the 1st, 2nd, 3rd or Nth \. Then left(), mid() and right can be used. Usually needs iferror() as well, but since you don't show what you are working with then I cannot guess or provide an example, however there are already examples of find() on here. – Solar Mike Aug 21 '23 at 20:52
  • 2
    Have you got acces to FILTERXML? Have a look [here](https://stackoverflow.com/q/61837696/9758194) – JvdV Aug 21 '23 at 21:25
  • Think about left(A1,find("\",A1,1)-1) to get the first string. – Solar Mike Aug 21 '23 at 21:30
  • Please clarify your specific problem or provide additional details to highlight exactly what you need. As it's currently written, it's hard to tell exactly what you're asking. – Community Aug 21 '23 at 22:31

0 Answers0