Split 20 Column headings last 5-6 characters only

[AntlRo]

Hello Everyone,

I have 20 column headings that I want only last 5-6 characters only... The data column headings all start with " Column - " and I only want the last 5 values or last 10 ..below is example  is simmilar to this:

|Column - Address | |Column - Name | | Column - Age |

I want the out put to only produce new column headings stating | Address |  | Name | |Age| etc....

Prompt feedback greatly appreciated! 

[Felipe_Ribeir0 · Accepted solution]

Hi @AntlRo 

One way of doing this, using the dynamic rename tool.

Input:

Output:

[AntlRo]

Yes that worked perfect! thanks! 

[jbrazeal]

You might just find and replace the “Column - “