I would like to know if it is possible to insert tab into text format? If it is, how can I do that?
I tried this formula: =A1&"\t"&A2 but it doesn’t work.
Thank you for your help in advance!
The formula
=A1&CHAR(9)&A2
can increase the length of the result string by one TAB character, but it will not be appeared in the cell. The code 09 is the ASCII code of the TAB character.
I suggest you to use a whitespace instead of the TAB.
1 Like
You have not explained what do you want to achieve.
Maybe alignment distributed can help.
You can add some padding.
Hello,
thanks for your help!
My goal is to generate program code rows in Calc that would be very repetitive if typed by hand.
For this, the insertion of the CHAR(9) function seems perfect. In the code editor, tabs appear in the text of the copied cells.
1 Like