Posted to microsoft.public.excel.programming

Ron Rosenfeld Ron Rosenfeld is offline

external usenet poster

Posts: 5,651

Duplicate phrases in one cell

On Mon, 18 May 2009 12:19:29 +0100, "Peter T" <peter_t@discussions wrote:

I don't fully follow the objective but based solely on your examples, it
looks like all you need to do is compare the left half with the right half.
You could do that with a VBA (could be a UDF) or with a simple formula, eg

=IF(LEFT(A1,LEN(A1)/2)=RIGHT(A1,LEN(A1)/2),LEFT(A1,LEN(A1)/2),A1)

Very simple, and neat.
--ron

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
Duplicate phrases in one cell	Ron Rosenfeld	Excel Programming	0	May 18th 09 06:15 PM
Finding Duplicate Phrases in a File	Mis	Excel Worksheet Functions	2	June 29th 06 12:39 AM
How to insert random phrases	Jooky	Excel Worksheet Functions	1	January 15th 06 06:16 PM
How to Replace Numbers with Phrases	Jerry Arnone, PMP	Excel Discussion (Misc queries)	1	June 29th 05 02:00 PM
How to Replace Numbers with Phrases	Jerry Arnone, PMP	Excel Discussion (Misc queries)	0	June 29th 05 12:37 PM

All times are GMT +1. The time now is 09:36 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us