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
|