Excel Help Hello, I need excel help. I have a 500+ data in column B. What I need

Question

Excel Help

Hello,

I need excel help. I have a 500+ data in column B. What I need is the formula which will look for particular text in the cell and copy that text to the next column. For eg:

Col A

dksdjs dsdsk ds ADH123 sds sdsd sdsd

dksdjs dsdsk ds ADH126 sds sdsd sdsd

dksdjs dsdsdj ddid jdk ds ADH125 sds sdsd sdsd

dksdjs dsdsk d ffhf f jfhfhf hfhfhfh s ADH1253 sds sdsd sdsd

dksdjs dsdsk ds ADH1253 sds sdsfdfd sdfdfddsd

dfdf dfdfdf dfdfdf dksdjs dsdsk ds ADH1253 sds sdsd sdsd

trtrt 64656 dksdjs dsdsk ds ADH1253 sds sdsd sdsd

Desired output (Column B)

ADH123

ADH126

ADH125

ADH1253

ADH1253

ADH1253

ADH1253

I need a formula which will ssearch for a text starting from "ADH*" and paste to the new cell.

I really appreciate help into this.

Thanks !!

Explanation / Answer

Hi..

Assuming your first string is in A2, put thiss in B2 and drag down.

=TRIM(MID(A2,FIND("ADH",A2),FIND(" ",A2,FIND("ADH",A2))-FIND("ADH",A2)))

or if AdH might not be in upper case use search like this.

=TRIM(MID(A2,SEARCH("ADH",A2),FIND(" ",A2,SEARCH("ADH",A2))-SEARCH("ADH",A2)))

Related Questions

Navigate

• Browse (All)
• Browse E
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.