Thanks Dave.

Much easier.

Where did you find CTRL + j


Gord

On Tue, 27 Sep 2005 22:11:13 -0500, 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