Data Modify

This function allows you to prolong or delete a sequence of symbols in a specified column in a file. Use this function when you need to put data into a certain format.

Example 1:

Initial table:

  A B C
1 1    
2 2    
3 3    
4 4    
5      
6      

Output table A: ("00" added)

  A B C
1 001    
2 002    
3 003    
4 004    
5      
6      

Output table B: (" /2005a" added)

  A B C
1 1/2005a    
2 2/2005a    
3 3/2005a    
4 4/2005a    
5      
6      

Example 2:

Initial table:

  A B C
1 000001    
2 000002    
3 000003    
4 000004    
5      
6      

Output table: (" 00000" deleted)

  A B C
1 1    
2 2    
3 3    
4 4    
5      
6      

Note: if there is no given sequence in the selected column the following message will display:

"String [sequence] in column [columnname] not found"

learn more



We want you to find this page by the following keywords:

data modification in excel, modify data, add sequence, re-format table data, column editing, change whole column, change the data, remove symbols from column, prolong sequence, modify data in batch mode
how it works:

load file(s)
open Function Wizard
choose Data Modify function
specify file number
specify column to apply changes
select cut/add command and enter symbol sequence
press Run button to get the results