Hello,

I am looking for some help in cleaning up some ones poor decisions. You see previously it was decided to have multiple inputs into a single cell. The example below shows all of the inputs in a single cell. IE

A
MSF 04/28/16: Received signature. Notified LMR to review.
MSF 04/27/16: Sent follow-up email for signature
1. MSF 03/22/16: Received certificate. Confirmed account is current. Need additional signature. Sent email to SC
MSF 03/15/16: Sent 1st email

Now I need to find a way to remove each input and leave only one in each cell. IE

A B C
1 MSF 04/28/16 Received Signature. Notified LMR for review.


2 MSF 04/27/16 Sent follow-up email for signature


I originally thought I could do this with an if than statement but not sure. So now I am asking you the excel gurus to help with finding a way to splice data and not having to manually edit each one which is 7000+ rows.