Excel VBA - Word to search for part of a word and replace full word

Hello there,

(post changed if your wondering i you have seen it before)

I have the following code that is mostly from google as a starting point:

Please Login or Register  to view this content.

however i cannot determine a way to use the code to replace an entire section of text, rather than just a part of it: e.g searching 4500 and replacing it with 45001111 if the text to replace is 4500xxxx

45001111xxxx

were i was wondering if it can be replaced as just:

45001111

hope that makes sence? any thoughts?

If you find a solution to your problem, I'll use it for an application I'm working on as well.

Unfortunately, I'm not at the point in my project where I'm working on this, but if I do work towards that and solve it, I'll post my results in the 1-2 month timeframe.

I've found that VBA doesn't work with Word nearly as well as Excel or Database files.

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

Hello charlie543,

There are more options to the Find method than what you have in your code. Find accepts the use of wildcard characters "*", "?", and "#".

The asterisk, "*", matches zero or more characters.

The question mark, "?", matches any single character.

The pound sign or hashtag, "#", matches any single digit.

You can also control whether to ignore case, search for a whole or partial word. Below is the amended macro to let you search using a partial match and replace it with the string you specify.

Please Login or Register  to view this content.