For example, what function or combination of functions would I use to convert string 1, "this_is_a_string" to string 2, "this is a string"?
1 Answer
Use substitute. Or if its a one off use find and replace dialogue box.
=SUBSTITUTE(a1,"_"," ")
-
Thank you! I was using the replace function, but couldn't figure out how to do more than one. Dec 18, 2013 at 22:58