find and replace

[rroswell86]

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

 

[rroswell86]

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

Thanks a bunch for your help!!

 

[Bob I]

CHAR(13)

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

Thanks a bunch for your help!!

:

 

[rroswell86]

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

 

[Bob I]

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

 

[Gord Dibben]

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