Replacing Chr(10) in a string
 

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

Thanks

Replacing Chr(10) in a string
 

CurrentString = Replace(CurrentString, Chr(10), ;", 1, -1,
vbBinaryCompare)

RBS


"Barb Reinhardt" wrote in message
...
I have a string I'll call "CurrentString" and I want to replace all values
of
Chr(10) with ;". How would I do this?

Thanks

Replacing Chr(10) in a string
 

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


"Barb Reinhardt" wrote:

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

Thanks