software

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: www.excelforum.com/member.php...oamp;userid=34237
View this thread: www.excelforum.com/showthread...hreadid=539893Armagan, the ASCII character for Alt Enter is 10, therefore, you can separate
the two records in each cell.
In a blank column use the formula:
= LEFT(A1,LEN(A1)-FIND(quot;*quot;,SUBSTITUTE(A1,CHAR(10),quot;*quot;,LEN(A1)-LEN
(SUBSTITUTE(A1,CHAR(10),quot;quot;))))) to get the first record.

In a second blank column use the formula:

=RIGHT(A1,LEN(A1)-FIND(quot;*quot;,SUBSTITUTE(A1,CHAR(10),quot;*quot;,LEN(A1)-LEN(SUBSTITUTE(A1,CHAR(10),quot;quot;))))) to get the second record.

You can then sort how you need. I don't know exactly how to put this in
VBA, but maybe someone in the discussion group can help with that. Hope this
helps you get started solving your problem.abc
defquot;armaganquot; wrote:

gt;
gt; Hi,
gt;
gt; I have a list which I am trying to sort. Some of the records contain 2
gt; records in the same cell and have text wrap enabled (so one appears on
gt; top of the other.
gt;
gt; Is there a way to split them without manually editing each and every
gt; cell?
gt;
gt; I can't do a replace as there is no delimeter/separator (other than the
gt; Alt-Enter used for text wrap)
gt;
gt; ideally I need a routine which can be combined into a macro/VBA if
gt; anyone can help.
gt;
gt; cheers
gt;
gt;
gt; --
gt; armagan
gt; ------------------------------------------------------------------------
gt; armagan's Profile: www.excelforum.com/member.php...oamp;userid=34237
gt; View this thread: www.excelforum.com/showthread...hreadid=539893
gt;
gt;


Cheers mate, that worked straight away

I'll try to find some way to work it into some VBA--
armagan
------------------------------------------------------------------------
armagan's Profile: www.excelforum.com/member.php...oamp;userid=34237
View this thread: www.excelforum.com/showthread...hreadid=539893