First of all bebo's formula works well
another approach may be copy paste below in B1 then hold control and shift together and then hit enter to make it array formula and drag to right
Third to extract all in column B1 you need to use VBA
Array formulas are...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
Bookmarks