I'm not sure why you've got the curly there, but try this:
=IF(ISNUMBER(SEARCH("spinning",A2)),"AUTOGEN",IF(ISNUMBER(SEARCH("typing",A2)),"Manual",""))
Hope this helps.
Pete
I'm not sure why you've got the curly there, but try this:
=IF(ISNUMBER(SEARCH("spinning",A2)),"AUTOGEN",IF(ISNUMBER(SEARCH("typing",A2)),"Manual",""))
Hope this helps.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks