Sue Compelling wrote:
Hi

I have an address cell which has data with multiple lines - eg:

School of Science
Medical University

and I want to do a Find all: carriage returns and replace with a comma -
though I don't know the code to use for the carriage returns ...

This might work for you

=SUBSTITUTE(A1,CHAR(10),",")