add one or more characters to the end of all selected cells in excel
Posted on 2013-06-10
I am trying to change the formula in a selected area of an excel 2010 spreadsheet to include the expression iferror(*," "). Where * is any expression currently to the right of the = sign. In other words I would want to change =f8 to =iferror(f8," "). I can figure out how to put 'iferror(' after the = sign by search and replace (and first puting ' in front so it doesn't execute, then getting rid of the ' once I am finished). I can't figure out a way to tack the
expression ," ") to the end of every expression. I assume some method using wildcards might work. I don't really want to write a VB script. But if thats the only way to do it, then I would be happy to listen to how to use that.