Excel change only part of a cell text

Question

In an excel document I want a certain text of a cell to be automatically enumerated when I copy the entire group of cells. Example of the explanation. - What I want is to copy the whole text and only modify the cell that says "text,50,Num" so that it is " text,51,Num" and in the next copy it is "text,52,Num" and in the next copy it is "text,53,Num".

Explanation is in the image. I would really appreciate your help if someone would make themselves available. Now I want a formula or something to do automatically because I’m going to repeat that context almost to the 10,000 issue.

sleep,1000,Delay        
tap,522,967,false,1,Tocar na mensagem       
sleep,1000,Delay        
tap,90,126,false,1,Tocar secao "a quem escrever"        
sleep,1000,Delay        
text,50,Num **Aqui onde diz 50, eu queria que no proximo copy paste ficasse 
51  De uma forma automática porque eu vou fazer até por exemplo 10,000
sleep,1000,Delay        

tap,31,55,false,1,Seta andar p/tras     
sleep,1000,Delay        
tap,522,967,false,1,Tocar na mensagem       
sleep,1000,Delay        
tap,90,126,false,1,Tocar secao "a quem escrever"        
sleep,1000,Delay        
text,51,Num ***Ficando assim 51 
sleep,1000,Delay        

tap,31,55,false,1,Seta andar p/tras     
sleep,1000,Delay        
tap,522,967,false,1,Tocar na mensagem       
sleep,1000,Delay        
tap,90,126,false,1,Tocar secao "a quem escrever"        
sleep,1000,Delay        
text,52,Num ***Ficando asim 52...   
sleep,1000,Delay        

What I was able to do is put a formula in an empty cell and change the value I want, but I have to do it manually over and over again ! Is there an automatic way ? An image of what I can do is attached

Answer 1

As your goal is "Automate copy" of the text, not necessarily in excel, I did in C#. Just you access in . NET Fiddle and copy the result.

Access . NET Fiddle: https://dotnetfiddle.net/6uViYu

Follows the code:

using System;
using System.Collections.Generic;

public class Program
{
    public static void Main()
    {

        for (int i =50; i <= 10000; i++)
        {
            Console.WriteLine("tap,31,55,false,1,Seta andar p/tras");
            Console.WriteLine("sleep,1000,Delay");
            Console.WriteLine("tap,522,967,false,1,Tocar na mensagem");
            Console.WriteLine("sleep,1000,Delay");
            Console.WriteLine("tap,90,126,false,1,Tocar secao \"a quem escrever\"");
            Console.WriteLine("sleep,1000,Delay");
            Console.WriteLine("text,"+i+",Num");
            Console.WriteLine("sleep,1000,Delay");
            Console.WriteLine("");
        }

    }
}

Upshot:

tap,31,55,false,1,Seta andar p/tras
sleep,1000,Delay
tap,522,967,false,1,Tocar na mensagem
sleep,1000,Delay
tap,90,126,false,1,Tocar secao "a quem escrever"
sleep,1000,Delay
text,50,Num
sleep,1000,Delay

tap,31,55,false,1,Seta andar p/tras
sleep,1000,Delay
tap,522,967,false,1,Tocar na mensagem
sleep,1000,Delay
tap,90,126,false,1,Tocar secao "a quem escrever"
sleep,1000,Delay
text,51,Num
sleep,1000,Delay

tap,31,55,false,1,Seta andar p/tras
sleep,1000,Delay
tap,522,967,false,1,Tocar na mensagem
sleep,1000,Delay
tap,90,126,false,1,Tocar secao "a quem escrever"
sleep,1000,Delay
text,52,Num
sleep,1000,Delay

tap,31,55,false,1,Seta andar p/tras
sleep,1000,Delay
tap,522,967,false,1,Tocar na mensagem
sleep,1000,Delay
tap,90,126,false,1,Tocar secao "a quem escrever"
sleep,1000,Delay
text,53,Num
sleep,1000,Delay

tap,31,55,false,1,Seta andar p/tras
sleep,1000,Delay
tap,522,967,false,1,Tocar na mensagem
sleep,1000,Delay
tap,90,126,false,1,Tocar secao "a quem escrever"
sleep,1000,Delay
text,54,Num
sleep,1000,Delay

tap,31,55,false,1,Seta andar p/tras
sleep,1000,Delay
tap,522,967,false,1,Tocar na mensagem
sleep,1000,Delay
tap,90,126,false,1,Tocar secao "a quem escrever"
sleep,1000,Delay
text,55,Num
sleep,1000,Delay

...Continues...

o . NET Fiddle Limited results, but just change the numbering.