A multi-line text field has one or many lines with information like below:

2 x part # 1 @ $50

3 x part # 2 @ $100

3 x part # 3 @ $150

I need to display this information in a separate field, but without the @ $50,@ $100, etc, like this:

2 x part # 1

3 x part # 2

3 x part # 3

I used NotRight([Calculations],"="), and it works, but only when there is one line. When there are multiple lines, it looks like this:

2 x part # 1 @ $50

3 x part # 2 @ $100

3 x part # 3 @

Is there a way to adapt the NotRight formula to work on multiple lines?

2 x part # 1 @ $50

3 x part # 2 @ $100

3 x part # 3 @ $150

I need to display this information in a separate field, but without the @ $50,@ $100, etc, like this:

2 x part # 1

3 x part # 2

3 x part # 3

I used NotRight([Calculations],"="), and it works, but only when there is one line. When there are multiple lines, it looks like this:

2 x part # 1 @ $50

3 x part # 2 @ $100

3 x part # 3 @

Is there a way to adapt the NotRight formula to work on multiple lines?