Dear experts
I have alphanumberic long string in cell and want to pull the numeric value from cell depend upon header Dead or killed and injured or wounded
whereas come along with text string in cell.
The 2001 HaSharon Mall suicide bombing in Netanya, Israel. 5 killed 100+ injured. pull like (5 killed) and (100+ Injured)
2002 Jaffa Street bombing. 1 dead,23 Wounded Pull like (1 dead) and (23 wounded)
find the attachmen
Bookmarks