Hi I was wondering if using a macro would be a good way to do this.
I have a bunch of cells that have 5 or 6 sentences in each cell. Each
sentence is separated by an Astrisk(*) or double Astrisk(**). Is there a
way to have excel take each sentence and put it into its own cell
automatically? instead of copying each sentence and pasting it into its
own cell one by one?

Thanks


--
ekafrawy
------------------------------------------------------------------------
ekafrawy's Profile: http://www.excelforum.com/member.php...o&userid=24387
View this thread: http://www.excelforum.com/showthread...hreadid=379764