hi, is it possible to find characters within a formula?
so far have portion of what looking for from different example, that "would"
work.

=TRIM(LEFT($AX$430,SEARCH(":",$AX$430,40)))

if describe correct: keep all left of semi-colon, start search at pos 40
for semi-colon.

am trying to find what line number is designated in a formula in the first
portion of an array. so this is the start. thanks.