Thread: How do I replace a carrige control(box) in excel using VB
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
LenJr LenJr is offline
external usenet poster
  
Posts: 10
Default How do I replace a carrige control(box) in excel using VB
I am using Excel to query an Access database. The query is pulling in a memo
field from Access. Excel is displaying the carriage control "chr(13)" as a
box. I can do a find replace using "chr(13)" changing it to a space until I
hit a cell that has to much data in it. I am getting a "formula too long"
error. Is there a way to use VB code to address this issue and replace this
"box"?
Reply With QuoteReply With Quote