Split up Account Street field

Question

I'm attempting to write a couple formula fields that will split up the BillingStreet by lines:

Example:

25 Fake Street

Apt 25K

Attn: Micah Perry

Street 2 = Apt 25K

Street 3 = Attn: Micah Perry

I'm trying to use FIND() to locate when the user types BR() but it doesn't look like I can look up a break in a text field. Any thoughts? Thanks!

Mayank Srivastava · Accepted Answer

Micha, it isn't straightforward but seems to be quite doable. Here's a post from stackexchange that has step by step instructions on how to do it:

Data Management