One way might be to use an adjacent column =substitute(a2,"/",char(10)) and
format cells to word wrapthen change formula to values and delete the
original column.
or a macro to do it for you.

--
Don Guillett
SalesAid Software

"Peter from Novartis" <Peter from wrote
in message ...
Hi,
I have a large number of cell entries, all separated by a "/", but I need
to
replace it by "ALT+ENTER" (the keys sequence one uses for placing several
expressions within the same cell onto separate lines of that same cell).