That doesn't appear to work. Firstly that makes the cell merge into the
next one and thus misses one cell out. Secondly, it cuts the word down
to the first word, some of the cells i need to have three words and
others two, e.g. hovis (one word) own label (two words) these are the
variable names, but im trying to cut the next bit out. Thats why I
thought macros would be the tool to do it, ratehr than use and excel
formula.

thanks for your input, that may help me in future.