Hi Dave

I hadn't realised that Ctrl-j did the same thing as Alt+Enter.

For this task, not only is it easier to describe, but much easier to use
when you are on a notebook keyboard without easy access to the numeric pad!!

Regards

Roger Govier


Dave Peterson wrote:
Another option:
select the range
edit|replace
what: (spacebar)
with: ctrl-j
replace all

(Ctrl-j might be easier to use and it's lots easier to describe! <vbg)

Gord Dibben wrote:

EditReplace

what: space

with: ALT + 0010 (from the numpad to the rightside of keyboard)

Replace all.

Gord Dibben Excel MVP

On Tue, 27 Sep 2005 17:12:49 -0500, wennerberg
wrote:


Can I do a search and replace to place an alt+<enter in text in a range
of cells. Data example is "Phoenix (SOUTH)". I always want what is in
parenthesis on a line by itself in the cell, so I'd like to replace
"SPACE (" with "alt+<enter ("
Any version of Excel, OK.
TIA