0

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 1

0

Use substitute. Or if its a one off use find and replace dialogue box.

=SUBSTITUTE(a1,"_"," ")

1
  • 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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .