search for a specific word and copy the word and the preceeding words until a comma
I wish to clarify that in the example, the words seem to not be
contained within a cell. But all of my entries that I want to
manipulate are contained within a cell and in the above example the
data is B1 to B5
|