I have 'words' in the form 123abcd456789. Only the final numbers are relevant, but copying and pasting is far easier as blocks of whole 'words'.
The cell in Calc is Text and I've tried the possible Right/Left functions with no luck. Wildcards don't work, unfortunately.
The only likely one (to me!) is Right, e.g. =RIGHT(123abcd456789;6) will work but =RIGHT(*************;6) won't.
Is there any way to do this, please?