Excel Functions: The Replace Function
Friday, June 1st, 2012When a part (or parts) of a data string need to be replaced with other data, the REPLACE function is you new best friend. Rather than re-enter all that data, Excel can do the work for you with this handy little gem from the function library.
