Excel change only part of a cell text

Question

Excel change only part of a cell text

Navigation

#1 by (0 votes)

-1

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

Explanationisintheimage.Iwasverygratefulforthehelpifanyonewasavailable. NowIwantaformulaorsomethingthatmakesitautomaticbecauseI'mgoingtorepeatthatcontextalmostuntil10,000.

sleep,1000,Delaytap,522,967,false,1,Tocarnamensagemsleep,1000,Delaytap,90,126,false,1,Tocarsecao"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 to put a formula in an empty cell and change the value I want, but I have to do this manually over and over again! Is there any automatic way around? Please find attached an image of what I can do

excel excel-vba

asked by anonymous 17.08.2017 / 15:12

1 answer

Handle .sql file Switch texts by images [closed]

score 0 · Accepted Answer

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

Fiddle .NET Access: link

Follow 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("");
        }

    }
}

Result:

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

... Continue ...

.NET Fiddle has limited results, but simply change the numbering.