View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default Inserting a CR into a text string

Pete' keyboard had a hiccup today; he meant to type CHAR(10)
best wishes
Bernard_Canada
www.stfx.ca/people/bliengme
remove caps from email

"rtbrd" wrote in message
...
I want to concatenate two strings in a worksheet to be used in a text box
in
a chart however I would like the two strings to appear on seperate lines
in
the text box. Is there a way to insert a carriage return between the two
concatenated strings in the worksheet?