View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
DHANANJAY DHANANJAY is offline
external usenet poster
 
Posts: 5
Default search for a specific word and copy the word and the preceeding words until a comma

Thank You very much,Kounoike.

Unfortunately, I am not a technical person and I tried running the
formula you have so painstakingly developed. When I ran that formula,
there is an error line, "subject or function not defined". When this
prompt appears, the word 'Mypickup' is highlighted. In fact, I just
copied the formula you wrote and did no change whatsoever to it.

I would appreciate if you take time to teach me how the formula works
so that I can better run it. Thank You