How to limit my data table header to the maximum number of allowable characters

[Esmat]

Hi,

my data file is an excel sheet where the header columns are very long text; how to trim the columns headers to the maximum allowable number of characters (250 character) all at once.

screen shot below shows the header name where I have mopre columns with very long text like this.

thanks

[mspanic]

Answer:
Use the Trick

1. Use First Row as Header
   

2. Transpose - to rotate and put all your header names in one column

Do transformation you want (in your case Extract → First characters → 250) and roll back all the process

• transpose again
• use first row as header

Hope that is what are you looking for.

[Esmat]

yes it works
much appreciated