Search for Text and return the text

[byterneedshelp]

Can you suggest a formula which would populate the data says If A2 contains "Apple", returns "Apple" else "Huawei" or "Nokia".
Note that the location of the brand, Capacity, Year and Model may not be arranged in that order.

Excel.JPG

[ben_hensel]

Please Login or Register  to view this content.

That do it?

Also I generally hope that you've got the data split into distinct rows instead of having all that crammed in one cell.

[KOKOSEK]

Brand (B2):

Please Login or Register  to view this content.

For the rest:
Could you attached sample file, please? Mess up info in description if you know that could be arranged in other order.

[byterneedshelp]

Hi Ben,

Thanks for your response.. unfortunately it was not as easy because the descriptions were not consistent.. Perhaps my examples were really bad.
some of the examples could be:

"Apple SOL fer, x3, ex2, 256GB, xxed, 2018, yuayxx, STE, A5"

I hope the function would be able to find its brand from the description.
Is it possible that I make a list of brands "Apple, Huawei, Xiaomi, Lenovo, LG, Samsung", then if Cell A2 matches any of those brands from the list, it would populate the brand to Cell B2?

[KOKOSEK]

Do you mean quotes in description? Indeed then both formulas give "Apple as result.
Is that issue now?

[GR00007]

Is this an import from a flat file (i.e: .csv)? You may be able to use Text to Columns with a comma delimiter.