Hi,

I have a list which I am trying to sort. Some of the records contain 2
records in the same cell and have text wrap enabled (so one appears on
top of the other.

Is there a way to split them without manually editing each and every
cell?

I can't do a replace as there is no delimeter/separator (other than the
Alt-Enter used for text wrap)

ideally I need a routine which can be combined into a macro/VBA if
anyone can help.

cheers


--
armagan
------------------------------------------------------------------------
armagan's Profile: http://www.excelforum.com/member.php...o&userid=34237
View this thread: http://www.excelforum.com/showthread...hreadid=539893