I want to extract a specific piece of text from another multi line text field.

Hi Patrick,

So, if you ALWAYS will get that kind of values in the Multi Line Text field (named Basic Data) as

Name: QuickBase
Move Date: 9/15/2016
Phone: 000-000-0000 

And you will have 3 fields to store each value.

First formula field is Name. The code would be:    NotRight(Part([Basic Data], 2, ":"),9)

Second formula field is Move Date. The code would be:   NotRight(Part([Basic Data], 3, ":"),5)

and the third formula field is Phone. The code would be:     Right([Basic Data],":")

The first formula will look for the second colon and bring what's on its left before the first colon.

The second formula does the same but starting from the third colon.

The third formula is just looking to extract anything that is on the right side of a colon, but, since it is a multi line it will bring every thing on the right side of the last colon.

It is not a very fancy code, but I think that might work for you. Cheers.