Originally Posted by
moblid
Hi Jindon, this works great...
Are you sure it works as you need it to all of the time? What if you had this in a cell...
45, 255-3, 212-24
Jindon's code changes the red highlighted part to this...
45, 255-253, 212-214
whereas I would think you would want it to change to this instead...
45, 255-263, 212-214
Am I correct on what I think you would want for such a situation? If so, then what should the red highlighted part below become
45, 255-34, 212-24
I am thinking 334... would that be correct? If so, give this macro a try...
Note: The above code looks in Column A for its data and puts the output in Column B (that is what you explicitly asked for in Message #1)>
Bookmarks