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


--
wennerberg
------------------------------------------------------------------------
wennerberg's Profile: http://www.excelforum.com/member.php...fo&userid=7321
View this thread: http://www.excelforum.com/showthread...hreadid=471253