Posted to microsoft.public.excel.programming

Tatsujin

external usenet poster

Posts: 25

Eliminate duplicate words from string

If I have a string of words, such as:

sWords = "person person woman man camera TV TV person man man"

What is an efficient way to remove duplicate words? The variable sWords should contain "person woman man camera TV".

Thanks!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Eliminate Duplicate Row	Chip	Excel Discussion (Misc queries)	1	September 25th 09 09:18 PM
how to eliminate duplicate numbers	OPer	Excel Worksheet Functions	5	September 11th 09 10:29 PM
Create a macro to eliminate certain words from several columns	Jorge	Excel Worksheet Functions	4	January 16th 08 08:15 PM
How to eliminate duplicate entries	Tara Keane	Excel Discussion (Misc queries)	4	March 2nd 05 05:33 PM
macro to eliminate spaces between words	CSAM	Excel Discussion (Misc queries)	3	December 17th 04 11:39 AM

All times are GMT +1. The time now is 06:47 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us