How do i use Find & 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
wrote:

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

Regards,

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:

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

Regards,

Shaun.

--

Dave Peterson