Replacing Chr(10) in a string

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a string I'll call "CurrentString" and I want to replace all values of
Chr(10) with "@domain.com;". How would I do this?

Thanks
 
CurrentString = Replace(CurrentString, Chr(10), "@domain.com;", 1, -1,
vbBinaryCompare)

RBS
 
Try this:

Select the cells to be impacted

Then....from the Excel Main Menu
<edit><replace>
Find what: Hold down the [alt] key....type 0010...release [alt] key
Replace with: @domain.com
Click the [Replace All] button

Does that help?
***********
Regards,
Ron

XL2002, WinXP
 
Back
Top