I’m trying to find a text string in a longer string and then have related numeric cell contents copied to another cell. This is probably a noob question but I’ve been searching it for hours and am even having difficulty explaining it.
See attached file:
edit: reworked example according to your question
ask_113434.ods (14.5 KB)
1 Like
Thank you for your prompt response. I’m caught up in other stuff at the moment but will try your suggestion shortly.