Replacing Chr(10) in a string

[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

 

[RB Smissaert]

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

RBS

 

[Guest]

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