Microsoft Office Tutorials and References
In Depth Information
Transforming Data by Using Temporary Formulas
7. Press Esc to cancel Copy mode.
8. When you’re satisfied that the transformation happened as you intended, you can delete
the temporary formulas in column C.
Figure 77-2: The formula results from column C replace the original data in column A.
You can adapt this technique for just about any type of data transformation you need. The key,
of course, is constructing the proper transformation formula in Step 1.