Solved: Delete plus Trim word

[Nicolaf]

Hi,

I would like to do two functions one after the other.

I have some fruit names in Cells A7:A14 eg. white apple, green pear etc.
Colours are only white or green while fruit has many types.

I need to go through list delete colour (white or green) and trim remaining word (apple, pear etc.)

How do I do that?

[TMShucks]

The easiest way would be to use Replace All. First replace "White " ... that's the word "White" with a space following it ... no quotes. Don't put anything in the replace box. Repeat with "Green ". You shouldn't need to "trim" but, if there are any residual spaces, just use Replace All again, replacing a space with nothing.

Regards, TMS

[Nicolaf]

Great thanks!

[TMShucks]

You're welcome.