Thanks FSt1 for the quick response - I also kept searching and discovered the
very simple
Find CTL J
Replace ,
Replace ALL
Brilliant
--
Sue Compelling
"FSt1" wrote:
hi
see this site...
http://en.allexperts.com/q/Excel-105...-returns-1.htm
regards
FSt1
"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 ...
Help
TIA
--
Sue Compelling