CODEWITHSUNDEEP
excelexcel-formula
user3357915
user3357915

Reputation: 1

Excel - finding partial text in a cell/range, return that text

I need to find partial text from specific cells/range and return that value in other cell.

Column A                 Column B
TP-K19-00041-SPC-A4-0    SPC
TP-K19-00042-DAS-A4-0    DAS
TP-K19-00043-WTD-A4-0    WTD

From above, partial text from Column A (example "SPC") is identified and copied in Column B. Currently, this is done manually, I wanted to know if there's a way to use any formula to automate this.

Upvotes: 0

Views: 1006

Answers (1)

Tim Sands
Tim Sands

Reputation: 1068

Sure - check out the MID function.

In your example, if you type the formula

=MID(A1,14,3)

You should get the desired output.

Upvotes: 1

Related Questions