I'm trying to make a pivot graph look nice for a Dashboard. X axis lables is far to long, so I've already run a vba that limits caracters to max 20.
But I also need a vba to add hard return to every cell in the whole column. Hard return should be added after caracter number 5 in all cells in column.
I'm using headers, so this should be done from M2 and to the end of active cells in column M.
Is this possible?
But I also need a vba to add hard return to every cell in the whole column. Hard return should be added after caracter number 5 in all cells in column.
I'm using headers, so this should be done from M2 and to the end of active cells in column M.
Is this possible?