Creating table from cell contents
Mornin' all,
I've got a table with company details on it, then a list
of product codes that the company sells.
I want to write a new table, for the moment just a new
worksheet would be great, based on the product codes.
I'd like to take a record like this (where the ' - ' bit
specifies a new column):
R1FQ33 - 20780P,41930P
and turn it into this:
R1FQ33 - 20780 - P
R1FQ33 - 41930 - P
Has anyone done something along these lines before? If so,
can you help me get started plese?
Thanks very much,
Foss
|