Hi everyone,

I have text data that I need to line up with a sequence of letters in columns. I'm using Excel for Mac 2011, so it doesn't have the newest tools. I'm pretty sure that I need the functions IF, AND, MID, LEN and maybe INDIRECT. The problem is that I can't figure out what order to write the logic statements. I have uploaded a screen shot of an example. The text to be distributed is in A3. The desired result is highlighted C7:R7. The sequence to be matched is in Row 2, with corresponding numbers in Row 1. Column B has the starting number of the text that is to be aligned. Please note that this is small example. The sequence is actually over 500 letters long and the some of my text inserts are above 30 letters long.

I placed the corresponding formulas used (w/o the =) in cells A4:A6. I did succeed in using "AND" to achieve the empty space and "INDIRECT" to get a single letter in a cell, but not with putting it all together.

Thanks,

Tynan

I have text data that I need to line up with a sequence of letters in columns. I'm using Excel for Mac 2011, so it doesn't have the newest tools. I'm pretty sure that I need the functions IF, AND, MID, LEN and maybe INDIRECT. The problem is that I can't figure out what order to write the logic statements. I have uploaded a screen shot of an example. The text to be distributed is in A3. The desired result is highlighted C7:R7. The sequence to be matched is in Row 2, with corresponding numbers in Row 1. Column B has the starting number of the text that is to be aligned. Please note that this is small example. The sequence is actually over 500 letters long and the some of my text inserts are above 30 letters long.

I placed the corresponding formulas used (w/o the =) in cells A4:A6. I did succeed in using "AND" to achieve the empty space and "INDIRECT" to get a single letter in a cell, but not with putting it all together.

Thanks,

Tynan