Thanks Dave and Bernard for the correction - too much VBA at the moment
<bg

Pete

Bernard Liengme wrote:

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?