View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
RB Smissaert RB Smissaert is offline
external usenet poster
 
Posts: 2,452
Default 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