Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

find and replace plz help

Status
Not open for further replies.
hello007

hello007

Programmer
Jan 7, 2004
1
US
hey im guys im new here i wanted to know if someone knew the code to read from a text file 2 different variables comma seperated and find the first variable in a excel file and replace it with the second one is this even possible thank
 
Sort by date Sort by votes
yes it can be done. Use something like
text1 = Replace(text1, "a", "b")
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

2009luca
  • Locked
  • Question
USE find instead to loop
Replies
2
Views
220
Andrzejek
Andrzejek
sal21
  • Locked
  • Question
FIND ARRAY IN OTHER ARRAY
Replies
3
Views
162
Andrzejek
Andrzejek
sal21
  • Locked
  • Question
Replace , with ; in txt file
Replies
7
Views
204
muaricewayne
muaricewayne
sal21
  • Locked
  • Question
FIND VALUE IN COLUMN 0 OF MSFKLEXGRID
Replies
0
Views
103
sal21
sal21
tomminil4
  • Locked
  • Question
Help with VBA code
Replies
3
Views
238
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top