Formula to Extract Text from Cell

I’m trying to figure out the formula to extract the below data and place it in another cell.

They will come in through emails and the content (below) will be pasted into a single cell, then will want to have the following columns set with the formulas to pull the Lead ID, Name, Email, and Phone without showing it’s Title (Lead ID:) and only showing characters for the entry.


So if this entire Text was pasted into A2, and I want A3 to show the “Lead ID” value of “M-5554444”, what would be the formula to do this?  I should be able to take it from there to create the formulas for Name, Email, etc.


Lead ID: M-5554444  

Name: Sample Name


Phone: 8885554444

By: Jon

1,269 thoughts on “Formula to Extract Text from Cell


    You actually make it seem really easy with your presentation however
    I find this matter to be actually something which I feel I might by no means understand.
    It kind of feels too complex and extremely broad for
    me. I’m having a look ahead in your subsequent publish,
    I’ll attempt to get the hold of it!

Leave a Reply

Your email address will not be published. Required fields are marked *