With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
I'm trying to extract all words from a cell that occur before one of several given words. The use case for this is separating metadata to extract the first artist listed in a bunch of different complex artist strings. Below is my practical example:
Johnny Music featuring Timothy Muzak
Johnny Music, Timothy Muzak, Kevin Current
Johnny Music & Timothy Muzak feat. Kevin Current
Johnny Music feat. Kevin Current & Timothy Muzak
Johnny Music remixed by Kevin Current
In all cases, the result I want is 'Johnny Music'.
I've tried a couple of LEFT, TRIM, and MID commands but they aren't letting me search for multiple different places to stop. For example:
Both of these failed to SEARCH beyond 'remixed by', so they only extracted 'Johnny Music' in the last case, not in the other cases (featuring, etc were not located by the search. I got a '#VALUE!' error).
Can anyone advise? Is there something obvious I am missing, or is this more complex than I first envisaged?
NOTE: This would be applied across multiple artist strings, so it's not as if all of them would start with 'Johnny Music' - therefore a simple LEFT with value parameters won't suffice.
I am trying to get data to rollover from multiple tabs. Ex from my doc. I want tabs 07/02,07/09,07/16 to have the sum of each cell go to the July recap tab. Please help. It would not let me upload as a google doc. I hope you get the idea.