Replace part of a string by another string

C

cyberdude

Hi,

I want to replace part of a string by another string. For example,

Dim A as string

A="I have a car. He has a house"

If "car" is to be replaced by "boat", how can I do that?

(So, A becomes "I have a boat. He has a house")

Thanks.

Mike
 
J

Jonathan West

cyberdude said:
Hi,

I want to replace part of a string by another string. For example,

Dim A as string

A="I have a car. He has a house"

If "car" is to be replaced by "boat", how can I do that?

(So, A becomes "I have a boat. He has a house")
Click to expand...

B = Replace(A, "car", "boat")
 
H

Helmut Weber

Hi Mike,

see help on replace function.


--

Greetings from Bavaria, Germany

Helmut Weber, MVP WordVBA

Vista Small Business, Office XP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word macro that can call cells out of Excel for a find and replace 0
Prompt For Replace in Selection And More... 0
Word VBA - Automatic change content of a cell in table using dropdown list 5
Replacing a phrase with carriage returns 1
VBA - exporting serial letters to single documents 0
Integrating information from Word to Excel (not mail merge) 1
parse string to multi records 2
Autonumber field in Excel that behaves the same as Access 0

Top