### Title

Using a range in Substitute function

### Post

Is there a way to specify a range in the Substitute function?

I have three fields: **OriginalText**, **RevisedText**, and **Date2Substitute**.

**RevisedText** is simply **OriginalText** with dates earlier than **Date2Substitute** replaced with **Date2Substitute**.

Here is the **RevisedText** calculation I'm using to go back 75 years:

**Substitute ( OriginalText ; **

**[Date2Substitute - 1 ; Date2Substitute ] ;**

**[Date2Substitute - 2 ; Date2Substitute ] ;**

**[Date2Substitute - 3 ; Date2Substitute ] ;**

**[Date2Substitute - 4 ; Date2Substitute ] ;**

**[Date2Substitute - 5 ; Date2Substitute ] ;**

**.... etc. for 75 lines)**

Thanks for any help.

Could you provide an example of the data?