How do i replace a known delimiter with a carage return?

[Guest]

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.

 

[Ron Rosenfeld]

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

 

[Dave Peterson]

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.