I have need to remove something around the first 11 lines of text from a field I copied  text to. 

But sometimes there are variations and it is 12 lines or 8 lines etc. It is easy to spot and I have a field called "ParagraphR" where I put the number of lines I need to remove.

 

So how can I remove the first 11 (or the number in the field  ParagraphR) of the text in the field 

"Mastertext" ?

 I would like to set the new field called "FinalText" with that remainder of text.

 

Thanks very much. 

Coping and pasting text,as you have discovered, isn't always the best way to handle import of data. The more control you can exercise over the data, the better the results.

Without seeing a sample of the text, we would be guessing at the best way to fix the problem.

Why not post a copy of the file and a copy of the text.

I would like to set the new field called "FinalText" with that remainder of text.

RightValues ( Mastertext ; ValueCount ( Mastertext ) - ParagraphR )

If you need to eliminate also the last carriage return ( inserted by the RightValues ( ) function ):

Let(
t = RightValues ( Mastertext ; ValueCount ( Mastertext ) - ParagraphR );
Left ( t ; Lenght ( t ) - 1 )
)

Excellent Thanks so much 

Works like a charm

Thanks