Extracting text from the cell

[NATALIA84]

Hi,

I have just started working with the Excel.

I have spreadshhet with around 2000 rows. There is one column which consists of product desctiption. The product descyption has more that two words. I am trying to extract specifick words (set of words) from the cells, for example from the cell Own Label Chicken Tikka Masala 250g I want to extract Tikka masala only. How can I do it?

Thanks

[Ron Coderre]

Welcome to the forum.
This is a moderated forum, so make sure you take a momemt to click the Forum Rules link near the top of the page. and read them.

About your issue:
Can you post some examples and the results you want to see, based on those examples?

[DannyJ]

Hi Natalia,

The code I think you are looking for is,

Please Login or Register  to view this content.

With that code if the words you are looking for aren't there it displays as blank.

Spreadsheet attached.

If you aren't using it to check and want it autofilled then let me know and I will post that.

Hope this helps

Daniel

[Kevin UK]

@ DannyJ

In NATALIA84 post:

I have spreadshhet with around 2000 rows

That will be a lot of times that formula has to be entered! I think they are looking for a quicker solution.