I have a cell (actually single-field merged range) with a text string. I need to take out the initial and trailing end characters that are NOT alpha.
So if the string is
;&3abc@wer!;er3ruu.rst.! the result will be 3abc@wer!;er3ru.rst
only the initial and trailing non-alpha chars were removed. The embedded non-alpha chars remain.
The solution could be something like two loops, one for the initial chars, the other for the end chars:
while initial char is not alpha
remove initial char
while last char is not alpha
remove last char