You could use edit and replace.

Say that you wanted to replace the pound sign (#) with the hard line break
(CHAR(10)).
First, select the cells containing the data to be changed, then:

<Edit <Replace
In the "Find What" box, enter
#
And in the "Replace With" box, enter
<ALT0010
Using the numbers on the num keypad, *not* the numbers under the function
keys.
You will not see anything displayed in the "Replace With" box,
But click "Replace All".

You should see your data wrapped in the cell.
If not, go to:
<Format <Cells <Alignment tab,
And click in "Word Wrap", then <OK.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"jo" wrote in message
...
excel 2003
how to find text or symbol in each cell and replace with hard carriage
return