extracting specific names from this data

[zeugma]

Hi Guys,

I have the below data in cell A1

name-john/birth-feb-name-sameer-name-deepak/birth-dec-name-mukesh-name-ryan/name-rob

I want to extract all the values against 'name' i.e. john, sameer, deepak....and so on

The actual list is a huge one so i was looking for either a formula or a macro code to do this.

Can anyone help ?

 

[Fennek]

Hi,

(unchecked)

use the split-function:

Sub Fen()
for i = 1 to cells(rows.count, "A").end(xlup).row
Ar = split(cells(i,"A"), "name")
msgbox ubound(Ar) & chr(10) & Ar(1) & chr(10) & Ar(2) & chr(10) & Ar(3) & chr(10) & Ar(4) & chr(10) & Ar(5) & chr(10) & Ar(6)
next i
End Sub

regards