software

How do i use Find amp; Replace from the menu to replace a known delimiting
character(eg a comma) with a carage return and/or line feed character?

Regards,

Shaun.

On Wed, 15 Mar 2006 06:31:07 -0800, Shaun_C gt;
wrote:

gt;How do i use Find amp; Replace from the menu to replace a known delimiting
gt;character(eg a comma) with a carage return and/or line feed character?
gt;
gt;Regards,
gt;
gt;Shaun.

I don't believe you can do that.

You'd have to use a VBA procedure.

Or, you should be able to do it within Microsoft Word.
--ron

I think you'll need VBA for carriage control, but you can use this for the line
feed:

Select the range
edit|replace
what: , (or whatever you want)
with: ctrl-j
replace all

You may have to change format|cells|alignment tab|wraptext to make it look
pretty.

You could use alt-0010 (from the numeric keypad) instead of ctrl-j if you want.
Shaun_C wrote:
gt;
gt; How do i use Find amp; Replace from the menu to replace a known delimiting
gt; character(eg a comma) with a carage return and/or line feed character?
gt;
gt; Regards,
gt;
gt; Shaun.

--

Dave Peterson