Extract text from a string in excel

Question

I want to extract the Test #. and the description that follows into two different columns side by side. Currently I have one long string. I want to break the string into two sets and extract only the needed information.

I have attached a screenshot to make it more clear. In the past I have used the MID function and FIND to extract text from strings, but since the strings here vary in length and content I'm not sure how to do this.

Thank you in advance!!

text 2 columns with a . deliminator and skip all useless fields — user4039065
– user4039065, Commented Oct 12, 2017 at 14:34

ImaginaryHuman072889 · Accepted Answer · 2017-10-12 14:49:16Z

3

Formula for cell A9:

= LEFT(A2,FIND(".",A2)-1)

Formula for cell B9:

= MID(A2,FIND(". ",A2)+2,FIND(" .",A2)-FIND(". ",A2)-2)

Drag formulas down as far as necessary.

answered Oct 12, 2017 at 14:49

ImaginaryHuman072889

5,2857 gold badges23 silver badges59 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Extract text from a string in excel

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related