Public Function getString() As String
getString = "hello" & Chr(10) & "world"
End Function


you will need to set wrap text on the cell as well

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Dave Dixson" wrote in message
ps.com...
I am trying to create a function that returns a string with a newline,
which when shown in a cell forces the cell to show on muliple lines as
if alt+enter was pressed.

Here is a test function I have tried....

Public Function getString() As String
getString = "hello" & vbLf & "worl"
end function

Unfortunatly, when I reference this function from within a cell in
excel it does not have the desired effect - it shows the new line as an
uprintable character (a rectangle appears in the cell), and the whole
string is shown on one string.

Anyone know what characters I should return from my function to get it
to display as a soft return in the cell?

Cheers,

Dave.