hi all..
i have problem, how to extract text before word "Golongan"
like this
Excel 2007 32 bit
<tbody>#888888[/URL] "]
#FFFFFF[/URL] ]A
#FFFFFF[/URL] ]B
#FFFFFF[/URL] "]
#888888[/URL] "]#FFFFFF[/URL] ]1
DATA/TEXT
EXTRACT
#FFFFFF[/URL] "]
#888888[/URL] "]#FFFFFF[/URL] ]2
Rumah Negara...