Forum Discussion
Tabs in Cell boxes
Thank you in advance. I would like to be able to use tabs within Cell boxes. Is that possible? If so can someone please tell me precisely how to do it using Excel 365 for Mac. Thank you.
waltcaweingmailcom Not sure what you have in mind, but you may use CHAR(9) to insert a tab character, as part of a formula that concatenates a text string. For example,
="Test"&CHAR(9)"Test"will create a text string "Test<tab>Test". Copy and paste as values and you will end up with two words in one cell, separated by a tab.
oh! A tab character!
i couldn’t get beyond “tab” as the word naming the different sheets that constitute an Excel workbook, appearing at the bottom of the screen, “Sheet1”. “Sheet2”......
To use, and even see tabs within the cell, if tab=sheet, is quite problematic. If only tab name...
mathetes Let's wait and see what kind of tab is required. Up to waltcaweingmailcom
