I need to write a macro that will take current cell content between "o/" and "/", remove hyphens and then add it to the end of the current cell contects. I know how to add text to the end of current cell contents, but cannot figure out how to do the rest. Any ideas?

I don't know whether this helps or not, but here is a way to assign a formula to the cell immediately to the right of the cell with the content in it. Since you already know how to concatenate strings, I won't mess with doing that here. This formula will return everything between the "o/" and "/", with the hyphens removed:

    ActiveCell.FormulaR1C1 = "=SUBSTITUTE(MID(RC[-1],SEARCH(""o/"",RC[-1])+2,SEARCH(""/"",RC[-1],SEARCH(""o/"",RC[-1])+2)-(SEARCH(""o/"",RC[-1])+2)),""-"","""")"

There are probably better ways to do it all in the VBA code, but depending on how urgently you need this, you can throw this in a loop and get it done the "quick and dirty" way.

Thank you!