Hello Everyone,

I am trying to extract certain words which starts from VRM in the cell. I've used below function but it extracts only the few instance where the condition is met and leaves the rest of word where the condition is met. I've attached a copy of the sample data for your reference.

=TRIM(MID(A4, FIND("VRM", A4), 12)) & ", " & TRIM(MID(A4, FIND("VRM", A4, FIND("VRM", A4) + 1), 12)) & ", " & TRIM(MID(A4, FIND("VRM", A4, FIND("VRM", A4, FIND("VRM", A4) + 1) + 1), 12))


Sample Data.xlsx