Hi there,
I'm looking to create multiple levels of indent in a single Excel cell, as a way of displaying hierarchy of information. Here's the situation:
I'm currently preparing a list of files and am using an Excel spreadsheet to keep track of each file. Each line in my spreadsheet is a different file, with unique identifying information in each column. Even though I need all this information stored in separate cells for usability, I also have two master cells for each line that regroup the information displayed in other cells.
Here's a simplified version of what the worksheet looks like so far:
NOTE: because this forum automatically deletes multiple subsequent spaces, I am using the notation [ ] to represent about 5 blank spaces, or one level of indent in this post. The bracket characters are not actually meant to appear in Excel.
[TABLE="class: grid, width: 800"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Master Code[/TD]
[TD]Master Title[/TD]
[TD]Prim[/TD]
[TD]Primary Series Title[/TD]
[TD]Sec[/TD]
[TD]Secondary Series Title[/TD]
[TD]File[/TD]
[TD]Unique File Name[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]100-05/FFTI[/TD]
[TD]PRIMARY TITLE FOR 100 SERIES
[ ]Secondary Title for 05 Subseries
[ ][ ]First File Title[/TD]
[TD]100[/TD]
[TD]PRIMARY TITLE FOR 100 SERIES[/TD]
[TD]05[/TD]
[TD]Secondary Title for 05 Subseries[/TD]
[TD]FFTI[/TD]
[TD]First File Title[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]200-20/AFTI[/TD]
[TD]PRIMARY TITLE FOR 200 SERIES
[ ]Secondary Title for 20 Subseries
[ ][ ]Another File Title that is longer and wraps around[/TD]
[TD]200[/TD]
[TD]PRIMARY TITLE FOR 200 SERIES[/TD]
[TD]20[/TD]
[TD]Secondary Title for 20 Subseries[/TD]
[TD]AFTI[/TD]
[TD]Another File Title that is longer and wraps around[/TD]
[/TR]
</tbody>[/TABLE]
The alphanumeric codes in columns C, E, G, and the file name in H are entered manually.
The titles in columns D and F are entered using VLOOKUP and HLOOKUP formulas that cross-reference that codes I enter in C, and E to a separate workbook that has all the codes and titles catalogued.
The formula in A2 is =C2&"-"&E2&"/"&G2 to build the unique file code.
The formula in B2 is =D2&CHAR(10)&"[ ]"&F2&CHAR(10)&"[ ][ ]"&H2
I would like the information in the B cells to display in the following way:
PRIMARY SERIES TITLE
[ ]Secondary Series Title
[ ][ ]Unique File Name
This is a display convention for the project I am working on. My B formula currently inserts 5 and 10 spaces before the second and third line, as a makeshift way of indenting the information for hierarchy.
My B column is currently wide enough that the primary and secondary titles display on a single line each, but the unique file name is sometimes long and wraps around to the next line without an indent, like you can see in my example above.
I tried indenting the information in columns F and H but the levels of indent do not carry over to column B.
Is there any way I can pull off a multi-level indent system that will display all the information from a given cell at a unique indent?
I'm looking to create multiple levels of indent in a single Excel cell, as a way of displaying hierarchy of information. Here's the situation:
I'm currently preparing a list of files and am using an Excel spreadsheet to keep track of each file. Each line in my spreadsheet is a different file, with unique identifying information in each column. Even though I need all this information stored in separate cells for usability, I also have two master cells for each line that regroup the information displayed in other cells.
Here's a simplified version of what the worksheet looks like so far:
NOTE: because this forum automatically deletes multiple subsequent spaces, I am using the notation [ ] to represent about 5 blank spaces, or one level of indent in this post. The bracket characters are not actually meant to appear in Excel.
[TABLE="class: grid, width: 800"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Master Code[/TD]
[TD]Master Title[/TD]
[TD]Prim[/TD]
[TD]Primary Series Title[/TD]
[TD]Sec[/TD]
[TD]Secondary Series Title[/TD]
[TD]File[/TD]
[TD]Unique File Name[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]100-05/FFTI[/TD]
[TD]PRIMARY TITLE FOR 100 SERIES
[ ]Secondary Title for 05 Subseries
[ ][ ]First File Title[/TD]
[TD]100[/TD]
[TD]PRIMARY TITLE FOR 100 SERIES[/TD]
[TD]05[/TD]
[TD]Secondary Title for 05 Subseries[/TD]
[TD]FFTI[/TD]
[TD]First File Title[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]200-20/AFTI[/TD]
[TD]PRIMARY TITLE FOR 200 SERIES
[ ]Secondary Title for 20 Subseries
[ ][ ]Another File Title that is longer and wraps around[/TD]
[TD]200[/TD]
[TD]PRIMARY TITLE FOR 200 SERIES[/TD]
[TD]20[/TD]
[TD]Secondary Title for 20 Subseries[/TD]
[TD]AFTI[/TD]
[TD]Another File Title that is longer and wraps around[/TD]
[/TR]
</tbody>[/TABLE]
The alphanumeric codes in columns C, E, G, and the file name in H are entered manually.
The titles in columns D and F are entered using VLOOKUP and HLOOKUP formulas that cross-reference that codes I enter in C, and E to a separate workbook that has all the codes and titles catalogued.
The formula in A2 is =C2&"-"&E2&"/"&G2 to build the unique file code.
The formula in B2 is =D2&CHAR(10)&"[ ]"&F2&CHAR(10)&"[ ][ ]"&H2
I would like the information in the B cells to display in the following way:
PRIMARY SERIES TITLE
[ ]Secondary Series Title
[ ][ ]Unique File Name
This is a display convention for the project I am working on. My B formula currently inserts 5 and 10 spaces before the second and third line, as a makeshift way of indenting the information for hierarchy.
My B column is currently wide enough that the primary and secondary titles display on a single line each, but the unique file name is sometimes long and wraps around to the next line without an indent, like you can see in my example above.
I tried indenting the information in columns F and H but the levels of indent do not carry over to column B.
Is there any way I can pull off a multi-level indent system that will display all the information from a given cell at a unique indent?
