Prev: protecting a file from extension change deletion or move
Next: running a Macro in 2007 which was created in 2003
From: david on 22 Apr 2010 04:00
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.

"Sue Compelling" wrote:

> 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-1059/rid-Carriage-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
 | 
Pages: 1
Prev: protecting a file from extension change deletion or move
Next: running a Macro in 2007 which was created in 2003