Let’s say, for example, you need to substitute something within a cell.
The immediate example that comes to mind for me is a to replace a space
with an underscore (you can see them in the highlighted box below if you
look closely). In case you don’t want to use the good old-fashioned
find/replace, you can use the substitute formula (found up in the
function bar). Or, for simplicity, start typing =substitute. Then, throw
on an open parenthesis and select the cell where the offending material
lives. Next, add in a comma, quotation marks containing the material
one wants to replace, another comma, the material one will be replacing
the offending material with, and a closed parenthesis. A visual probably
makes this explanation much more bearable:
0 comments:
Post a Comment