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

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

Answer:
Use the Trick

  1. Use First Row as Header
    image

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

image

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.

2 Likes

yes it works
much appreciated

1 Like