Nicolaf
04-17-2012, 02:59 AM
Hi,
I have a list of items in range C21:C27 in Sheet1.
The items are composed of two parts: one is fruit one is country of origin eg. apples France, pears Italy, Kiwis New Zealand.
I would like to copy them in range C21:C27 Sheet2 but without the country name.
Between fruit and country there is always one space (but same cell).
How do I do that?
Thanks,
:dunno :doh:
I have a list of items in range C21:C27 in Sheet1.
The items are composed of two parts: one is fruit one is country of origin eg. apples France, pears Italy, Kiwis New Zealand.
I would like to copy them in range C21:C27 Sheet2 but without the country name.
Between fruit and country there is always one space (but same cell).
How do I do that?
Thanks,
:dunno :doh: