PDA

View Full Version : Solved: Copy only part of items



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:

BrianMH
04-17-2012, 03:23 AM
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
04-17-2012, 04:13 AM
Great thanks!

Nix
:hi: :hi: