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.
<tbody>
</tbody>
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.
A | B | C | D | E | F | G | H | |
1 | Master Code | Master Title | Prim | Primary Series Title | Sec | Secondary Series Title | File | Unique File Name |
2 | 100-05/FFTI | PRIMARY TITLE FOR 100 SERIES [ ]Secondary Title for 05 Subseries [ ][ ]First File Title | 100 | PRIMARY TITLE FOR 100 SERIES | 05 | Secondary Title for 05 Subseries | FFTI | First File Title |
3 | 200-20/AFTI | PRIMARY TITLE FOR 200 SERIES [ ]Secondary Title for 20 Subseries [ ][ ]Another File Title that is longer and wraps around | 200 | PRIMARY TITLE FOR 200 SERIES | 20 | Secondary Title for 20 Subseries | AFTI | Another File Title that is longer and wraps around |
<tbody>
</tbody>
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?