Solved: Copy only part of items

[Nicolaf]

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,

[BrianMH]

If you didn't want to overwrite any data the simplest way would be to copy and paste those items to a new sheet and then use text to columns to split them and then copy them to to sheet2.

[Nicolaf]

Great thanks!

Nix