hi all..
how to extract data/text only before string "No."
this my layout :
Excel 2007 32 bit
EF
2dataexpected result
3 Street Sudirman No. 233 Sumahilang Pekanbaru Street Sudirman
4 Street Kandis Gg Antara No. 10 Pekanbaru Street Kandis Gg Antara
5 Street KH. Ahmad Dahlan No. 2C...