How can I find an Excel formula that helps me change text?

15 pts.
Tags:
Find and Replace
Microsoft Excel
Microsoft Excel formulas
Microsoft Word
How can I find a formula that helps me change letters in typed words without the daunting task of retyping them again? For example, I typed (in a table) 100 words ending in -d, and I want the same words just without the -d or with -s instead. Or can I join letters to form different words? Copy and paste in Word doesn’t help. Can formulas in Excel do this?

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Good Luck!
-Flame

————————————-

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)
</a>

————————————–

Hi,
YOU CAN USE REPLACE COMMAND.
Syntax

REPLACE(old_text,start_num,num_chars,new_text)

REPLACEB(old_text,start_num,num_bytes,new_text)

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.

GOOD LUCK!!!!!!!!!!!!!!!!!!!!
Regards,
Areena

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following