Just for internal documentation, I took care of two issues that I knew of, and I'll tell exactly how:
A. Took care of the leading zeros in the parent sheet (1 instead of 01), by replacing 1 with " '01 " (without quotes and spaces, but with that apostrophe - nuthin' else helped, believe me!!).
B. The illegal "|0" thingy at the parent_scope column - I took care of that by conditionally truncating the last two chars if they were |0, using this function:
Just for internal documentation, I took care of two issues that I knew of, and I'll tell exactly how:
A. Took care of the leading zeros in the parent sheet (1 instead of 01), by replacing 1 with " '01 " (without quotes and spaces, but with that apostrophe - nuthin' else helped, believe me!!).
B. The illegal "|0" thingy at the parent_scope column - I took care of that by conditionally truncating the last two chars if they were |0, using this function:
(applicable for row # 6132)
=IF(RIGHT(C6132,2)="|0",LEFT(C6132,LEN(C6132)-2),C6132)