Try using the “Replace…” function on word. It is located in the Edit menu. You might have to expand the edit menu to see it.
Yes, excel formulas can do that.
Have a look at the following pages:
<a href=”http://www.codeforexcelandoutlook.com/blog/2009/01/excel-tutorial-series-text-functions/”>Excel Tutorial Series – Text Functions</a>
<a href=”http://www.techonthenet.com/excel/formulas/”>Excel Topics: Formulas/Functions (By Category)
YOU CAN USE REPLACE COMMAND.
Old_text is text in which you want to replace some characters.
Start_num is the position of the character in old_text that you want to replace with new_text.
Num_chars is the number of characters in old_text that you want REPLACE to replace with new_text.
Num_bytes is the number of bytes in old_text that you want REPLACEB to replace with new_text.
New_text is the text that will replace characters in old_text.