Hi,
I have A1:A118 full of data, I only need to extract the following: MID(A19;FIND("1057";A19);10) which is fine to get 1 outcome per line, however the issue is there are 3 matching items in 1 cell sometimes, I assume it can be done with INDEX function. Basically I need all items that start with 1057 to be returned.
Could you please help out?
Thank you very much.
Bookmarks