find and replace
 

I exported outlook information into excel. Where there was a return in the
address, I get two thick vertical bars, which operate like a return when mail
merged to Word.

I want to replace the return with a comma and a space. Is this possible?

Thanks for your help!

Diane

find and replace
 

Hi Diane

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

--
Regards
Roger Govier

"rroswell86" wrote in message
...
I exported outlook information into excel. Where there was a return in
the
address, I get two thick vertical bars, which operate like a return when
mail
merged to Word.

I want to replace the return with a comma and a space. Is this possible?

Thanks for your help!

Diane

find and replace
 

This replaced the double vertical line with a single one. Any way to remove
the single one?

Thanks a bunch for your help!!

"Roger Govier" wrote:

Hi Diane

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

--
Regards
Roger Govier

"rroswell86" wrote in message
...
I exported outlook information into excel. Where there was a return in
the
address, I get two thick vertical bars, which operate like a return when
mail
merged to Word.

I want to replace the return with a comma and a space. Is this possible?

Thanks for your help!

Diane

find and replace
 

CHAR(13)

rroswell86 wrote:

This replaced the double vertical line with a single one. Any way to remove
the single one?

Thanks a bunch for your help!!

"Roger Govier" wrote:


Hi Diane

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

--
Regards
Roger Govier

"rroswell86" wrote in message
...

I exported outlook information into excel. Where there was a return in
the
address, I get two thick vertical bars, which operate like a return when
mail
merged to Word.

I want to replace the return with a comma and a space. Is this possible?

Thanks for your help!

Diane

find and replace
 

You guys are great! How can I get a list of these characters?

"Bob I" wrote:

CHAR(13)

rroswell86 wrote:

This replaced the double vertical line with a single one. Any way to remove
the single one?

Thanks a bunch for your help!!

"Roger Govier" wrote:


Hi Diane

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

--
Regards
Roger Govier

"rroswell86" wrote in message
...

I exported outlook information into excel. Where there was a return in
the
address, I get two thick vertical bars, which operate like a return when
mail
merged to Word.

I want to replace the return with a comma and a space. Is this possible?

Thanks for your help!

Diane

find and replace
 

What you had was a CRLF or Carriage Return, Line Feed combo, see link
below.
http://www.asciitable.com/

rroswell86 wrote:

You guys are great! How can I get a list of these characters?

"Bob I" wrote:


CHAR(13)

rroswell86 wrote:


This replaced the double vertical line with a single one. Any way to remove
the single one?

Thanks a bunch for your help!!

"Roger Govier" wrote:



Hi Diane

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

--
Regards
Roger Govier

"rroswell86" wrote in message
...


I exported outlook information into excel. Where there was a return in
the
address, I get two thick vertical bars, which operate like a return when
mail
merged to Word.

I want to replace the return with a comma and a space. Is this possible?

Thanks for your help!

Diane

find and replace
 

In A1 enter =CHAR(ROW())

Copy down to A255

You will see the characters represented by the row numbers.

Note: quite a few look the same.


Gord Dibben MS Excel MVP


On Thu, 28 May 2009 09:46:02 -0700, rroswell86
wrote:

You guys are great! How can I get a list of these characters?

"Bob I" wrote:

CHAR(13)

rroswell86 wrote:

This replaced the double vertical line with a single one. Any way to remove
the single one?

Thanks a bunch for your help!!

"Roger Govier" wrote:


Hi Diane

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

--
Regards
Roger Govier

"rroswell86" wrote in message
...

I exported outlook information into excel. Where there was a return in
the
address, I get two thick vertical bars, which operate like a return when
mail
merged to Word.

I want to replace the return with a comma and a space. Is this possible?

Thanks for your help!

Diane