Dear All,
I have generated a formula by rotating special character as per attachment.
In Cell A2, I have typed a word and stretch it downwards till (number of rows = equal to its length) from A3 to A16
In C1 I have inserted a special character and linked with A3 to A16 for rotating it from left to right.
Similarly from B3 to B16 special character from right to left.
Likewise, from B20 to J21, special character has been rotated (Column Wise).
However, whenever any formatting is done on the special character, like strikethrough, superscript, subsrcript, etc, font size, etc it will appear as a plain text only from A3 to B16 and B20 to J21. I also tried insert symbol but not accurate.
Is it possible to rotate the special character after specified formatting within the range ? Here, there are 4 different functions. (2 each in row wise and column wise). I do hope this may be possible through macro.
Any ideas /suggestions appreciated.
VDS
I have generated a formula by rotating special character as per attachment.
In Cell A2, I have typed a word and stretch it downwards till (number of rows = equal to its length) from A3 to A16
In C1 I have inserted a special character and linked with A3 to A16 for rotating it from left to right.
Similarly from B3 to B16 special character from right to left.
Likewise, from B20 to J21, special character has been rotated (Column Wise).
However, whenever any formatting is done on the special character, like strikethrough, superscript, subsrcript, etc, font size, etc it will appear as a plain text only from A3 to B16 and B20 to J21. I also tried insert symbol but not accurate.
Is it possible to rotate the special character after specified formatting within the range ? Here, there are 4 different functions. (2 each in row wise and column wise). I do hope this may be possible through macro.
Any ideas /suggestions appreciated.
VDS