REPLACE function


This function returns the second argument if the condition is met, otherwise it returns the third argument.



=REPLACE( old_textstart_numnum_charsnew_text )


required arguments:

old_text The text string to replace.
start_num Starting position.
num_chars The number of characters to replace.
new_text The text used to replace the specified portion of the old text.

Skillshare’s usually $10 a month, but because you’re an OfficeTuts reader you can get your first month free by clicking here. That’s unlimited access to over 18,000 classes on Excel, VBA, and much more.