I want to paste parts of this result in B28 to my image editor.

https://www.dropbox.com/s/y8awz4ldn8...lly-1.jpg?dl=0

Can I change the formula or its underlying format so that the correct
text appears in the edit box?

Alternatively, could I place another formula below it that would give me
that access?

Or must I do it manually with Paste Special Value? Or resort to
pasting the entire string to the clipboard and selectively pasting in
the external application (my image editor)?

Terry, East Grinstead, UK

The 'default' property of a cell is 'Value'!
The text that appears is EXACTLY what the formula is structured to return. If
you want a different value displayed then either...

reconstruct the formula accordingly;

construct a new formula in another cell that returns the EXACT text
you want to put in your 'edit box';

...then paste the cell's Value into your 'edit box'.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion