I have a bunch of cells which contain data similar to "[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]0.120 (3.048)". I want to delete everything out side the brackets. Is there an easy way to do this?
1) Your input data begins in cell A1.
2) Each input contains one, and ONLY one, instance of the "(" character. So never 2 or 3 of these, and they are never entirely absent.
3) Same as (2) for the ")" character.
Hi there. You can do it with 2 replaces. First, replace "*(" with nothing (leave the replace text blank). The replace ")*" in the same way. If you are wanting to do this many times, just record yourself doing it into a macro.
Another minor comment - my solution replaces the data in situ, both the others require the formula to be in a separate cell. If you want to keep the brackets my solution can be modified the use a replace value of "(" for the first, and ")" for the second. (rereading your original post, that's what you wanted I think).