Tabs in Cell boxes

%3CLINGO-SUB%20id%3D%22lingo-sub-1621601%22%20slang%3D%22en-US%22%3ETabs%20in%20Cell%20boxes%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1621601%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20in%20advance.%20%26nbsp%3BI%20would%20like%20to%20be%20able%20to%20use%20tabs%20within%20Cell%20boxes.%20Is%20that%20possible%3F%20If%20so%20can%20someone%20please%20tell%20me%20precisely%20how%20to%20do%20it%20using%20Excel%20365%20for%20Mac.%20%26nbsp%3BThank%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1621601%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1621837%22%20slang%3D%22en-US%22%3ERe%3A%20Tabs%20in%20Cell%20boxes%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1621837%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F776135%22%20target%3D%22_blank%22%3E%40waltcaweingmailcom%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20you%20tell%20us%20precisely%20what%20you%20mean%20by%20%22tabs%20within%20Cell%20boxes%22%20--then%2C%20if%20it's%20possible%2C%20we%20might%20be%20able%20to%20tell%20you%20how.%20That%20expression%2C%20that%20label%2C%20didn't%20mean%20anything%20to%20me...and%20I%20do%20use%20Excel%20365%20for%20Mac%20as%20well....%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMaybe%20more%20to%20the%20point%3A%20exactly%20what%20is%20it%20that%20you're%20trying%20to%20accomplish%3F%20What%20is%20your%20application%2C%20your%20%22business%20need%22--whether%20personal%20or%20not%2C%20what's%20the%20objective%20here%20that%20you're%20using%20Excel%20for%3F%20The%20more%20you%20can%20describe%20the%20task%2C%20the%20better%20we'll%20be%20able%20to%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1622098%22%20slang%3D%22en-US%22%3ERe%3A%20Tabs%20in%20Cell%20boxes%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1622098%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F776135%22%20target%3D%22_blank%22%3E%40waltcaweingmailcom%3C%2FA%3E%26nbsp%3BNot%20sure%20what%20you%20have%20in%20mind%2C%20but%20you%20may%20use%20CHAR(9)%20to%20insert%20a%20tab%20character%2C%20as%20part%20of%20a%20formula%20that%20concatenates%20a%20text%20string.%20For%20example%2C%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3D%22Test%22%26amp%3BCHAR(9)%22Test%22%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3Bwill%20create%20a%20text%20string%20%22Test%3CTAB%3ETest%22.%20Copy%20and%20paste%20as%20values%20and%20you%20will%20end%20up%20with%20two%20words%20in%20one%20cell%2C%20separated%20by%20a%20tab.%3C%2FTAB%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1622635%22%20slang%3D%22en-US%22%3ERe%3A%20Tabs%20in%20Cell%20boxes%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1622635%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eoh!%20A%20tab%20%3CEM%3E%3CSTRONG%3Echaracter%3C%2FSTRONG%3E%3C%2FEM%3E!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ei%20couldn%E2%80%99t%20get%20beyond%20%E2%80%9Ctab%E2%80%9D%20as%20the%20word%20naming%20the%20different%20sheets%20that%20constitute%20an%20Excel%20workbook%2C%20appearing%20at%20the%20bottom%20of%20the%20screen%2C%20%E2%80%9CSheet1%E2%80%9D.%20%E2%80%9CSheet2%E2%80%9D......%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1622659%22%20slang%3D%22en-US%22%3ERe%3A%20Tabs%20in%20Cell%20boxes%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1622659%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F425987%22%20target%3D%22_blank%22%3E%40mathetes%3C%2FA%3E%26nbsp%3BLet's%20wait%20and%20see%20what%20kind%20of%20tab%20is%20required.%20Up%20to%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F776135%22%20target%3D%22_blank%22%3E%40waltcaweingmailcom%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1622753%22%20slang%3D%22en-US%22%3ERe%3A%20Tabs%20in%20Cell%20boxes%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1622753%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F425987%22%20target%3D%22_blank%22%3E%40mathetes%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ETo%20use%2C%20and%20even%20see%20tabs%20within%20the%20cell%2C%20if%20tab%3Dsheet%2C%20is%20quite%20problematic.%20If%20only%20tab%20name...%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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.

5 Replies

@waltcaweingmailcom 

 

Can you tell us precisely what you mean by "tabs within Cell boxes" --then, if it's possible, we might be able to tell you how. That expression, that label, didn't mean anything to me...and I do use Excel 365 for Mac as well....

 

Maybe more to the point: exactly what is it that you're trying to accomplish? What is your application, your "business need"--whether personal or not, what's the objective here that you're using Excel for? The more you can describe the task, the better we'll be able to help.

@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.

@Riny_van_Eekelen 

 

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”......

@mathetes Let's wait and see what kind of tab is required. Up to @waltcaweingmailcom

@mathetes 

To use, and even see tabs within the cell, if tab=sheet, is quite problematic. If only tab name...