Creating an Index, locking lines?

**Eric101** · 02-01-2011, 03:29 AM

Hi. I'm making an index and have already entered in most of the information. Im trying to format it and having trouble with google search results.

Basically I'm trying to lock each horizontal lines information, so that the corresponding cell in column E (page # ) reacts with the first letter in either column a, b, or c. I'm also trying to sub alphabetize, so that A column is alphabetized first, then the b parts relating to a, and then the c parts relating to b. Hopefully this is clear enough to understand.

Also trying to find a formula that would capitalize the first letter in ever cell in columns a, b, and c.

Thanks in advance if you're able to help.

-Eric

**royUK** · 02-01-2011, 03:51 AM

This will capitalise the first letter in A1, place it in B1 & copy down

=PROPER(LEFT(A1,1))&RIGHT(A1,LEN(A1)-1)

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

**Eric101** · 02-01-2011, 06:33 PM

Thank you for your quick response.

I've attached one of the pages of the index. Basically I'm trying to find a way to have the index so that the page number on the far right side of the row remains on the same line as the subject, but the subjects are re-ordered alphabetically, also keeping in mind that the b column is related to the most recent subject of a, same as with c to b, and d to c. Is this possible?