Formula to break a string of text onto 2 separate strings of text

#1

I have a string of text that I want to break into two separate strings of text.
Here’s an example:

  • This is an example string of text / I want to break it into two separate strings of text

I want all of the words that precede the “/” to be one string of text. And then I want all of the words that come after the “/” to be a separate string of text. I want to completely eliminate the “/”.

So, to recap, we start with this:

  • This is an example string of text / I want to break it into two separate parts

And then we end-up with this:

  • This is an example string of text
  • I want to break it into two separate parts
#2

If you want them in two fields, use this for the Before field (replace Name with your own source field name):

LEFT(Name, FIND("/", Name) - 2)

…and this for the After field:

RIGHT(Name, LEN(Name) - FIND("/", Name) - 1)

If you want the two lines combined into one field on separate lines:

LEFT(Name, FIND("/", Name) - 2) & "\n" &
    RIGHT(Name, LEN(Name) - FIND("/", Name) - 1)

29%20PM

#3

AMAZING! This totally worked. Thank You!