Here, try this:
Formula:
=TRIM(MID(A3;SEARCH("Fra";A3)+4;MIN(SEARCH({" ref";" lag";" lug"};MID(A3;SEARCH("Fra";A3)+4;255)&" ref lag lug"))))
Here, try this:
Formula:
=TRIM(MID(A3;SEARCH("Fra";A3)+4;MIN(SEARCH({" ref";" lag";" lug"};MID(A3;SEARCH("Fra";A3)+4;255)&" ref lag lug"))))
Never use Merged Cells in Excel
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks