just a thought, but it wouldn't work in Excel 97.

Regards,
Tom Ogilvy

Dick Kusleika wrote in message
...
Shauna

I just tested this one, so I know it works

Range("a1").Value = Replace(Replace(olci.BusinessAddress, Chr(10), ""),
Chr(13), "")

That needs to be on one line.

--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.

"Shauna Kopang" wrote in message
...
Got your coding - Thanks!!

Tried the Replace and could not get it to work. Is that
the complete code? When I paste it in, it appears in Red.

Get error - Compile Error
Expected: Expresion

Again this is what you sent me

Range("D4").Value =
Replace(Replace(olCi.BusinessAddress,Chr(10),""),C hr
(13),"")

Thanks!
Shauna