Get leftmost character of a filtered line

[jomili]

I filter my criteria down to a single line. The value in Column 7, on the visible row, is "D0".

When I try this:

Please Login or Register  to view this content.

Result is a blank. But if I do

Please Login or Register  to view this content.

the result is "D0". How do I return just the "D"?

[jindon]

Not tested

Please Login or Register  to view this content.

[jomili]

And a Direct Hit! Way to go Jindon! You just rocked my world; thank you!