Replacing carriage returns with a comma

S

Sue Compelling

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 ...

Help

TIA
 
S

Sue Compelling

Thanks FSt1 for the quick response - I also kept searching and discovered the
very simple

Find CTL J
Replace ,
Replace ALL

Brilliant
 
S

smartin

Sue said:
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),",")
 
D

david

thanks sue the ctrl J worked for me. the Alt 013 didnt - saved me a couple of
couple of delete down arrow, delete down arrow, delete down arrow.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top