G Guest Nov 7, 2006 #1 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
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
R RB Smissaert Nov 7, 2006 #2 CurrentString = Replace(CurrentString, Chr(10), "@domain.com;", 1, -1, vbBinaryCompare) RBS
G Guest Nov 7, 2006 #3 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
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