Hi

Take a look at the Data Text to Columns Wizard.
Assuming your comma separate words are in column B, ensure you have
sufficient blanks columns to the right of column B to account for the
maximum number of words likely to be found in a cell.
Mark column B then
DataText to ColumnsDelimitedtick CommaNextFinish

--
Regards

Roger Govier


"doon" wrote in message
...
hi all,

i seem to have been a bit stupid about this befo this was meant to
be a
questions to the group and NOT a suggestion to microsoft. i also put
it into
the wrong cetegory. apologies folks, i haven't been here in a while.
sorry!

MY QUESTION:
i have searched the posts here, but have not really found the answer
to my
particular problem.

i have an evaluation sheet i am building. in one column i am capturing
key
words for a particular topc. these key words are comma separated.
example:

1 TOPIC: KEYWORDS:
---------------------------------------------------------
2 RFID Shopping, security, inventory
3 UPC Shopping, inventory

what i want is twofold: i want to be able to parse out each word per
cell
per row into a separate area (range of cells or other worksheet) with
duplicates removed. my result would be:

1 KEY WORDS:
---------------------------------------------------------
2 inventory
3 security
4 shopping

doesn't have to be alphabetized, but could be nice.

if this cannot be done on-the-fly but can be done with a macro (e.g. a
button i have to explicitly press to generate this), then great.

i have check out a ton of sites and see bits and pieces, but i am too
green
with VBA to know how to make it work.

any help would be greatly appreciated!

thanks,
doon

Using:
- Excel 2003 (v.11 build 6113)
- WinXP SP2
- 512 MB RAM

p.s. any way i can remove my previous post in the "general questions"
section?