PDA

View Full Version : Solved: Delete plus Trim word



Nicolaf
03-07-2012, 09:55 AM
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?

:dunno :help :dunno

TMShucks
03-07-2012, 10:05 AM
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
03-07-2012, 10:16 AM
Great thanks!

:hi: :hi: :hi:

TMShucks
03-07-2012, 04:06 PM
You're welcome. :hifive: