Hey everyone,
I have a long list of around 400 phrases, all in their individual cells. My problem is some of the terms have duplicate words in them.
Here's an example: http://i51.tinypic.com/1ttpg5.jpg
Is there any way to remove this duplicate text from the cell?
Thanks,
Russell
Realistically you would need to use a User Defined Function for this (VBA).
One such example being:
The above, stored in a standard Module in a Macro Enabled file would be called from your Excel sheet like any other function, eg:
Please Login or Register to view this content.
Space delimiter is assumed if not specified.Please Login or Register to view this content.
There are plenty of alternate routes you can take for this type of thing.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Have just installed & working well BUT only for cells that have less than 255 characters! I have cells that have many thousands in some instances. Can the code be modified?
how the heck do you get many thousands in on cell! thats not what excel is intended for! and besides which with thousands there is a fair chance of just leaving gibberish!
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
changeOriginally Posted by trivia
toPlease Login or Register to view this content.
the former is restricted to 255 chars whereas the latter is notPlease Login or Register to view this content.
(I did not know this previously!)
@trivia - going forward please ensure you ask your own questions in your own threads (provide links to other threads as nec.) - on this occasion given this highlights a flaw in the original I have left as is.
Last edited by DonkeyOte; 11-18-2010 at 04:21 AM.
Thanks! Works perfect!
I would much appreciate if this function may be converted into a SUB macro? I have the same problem, but have no idea how to do that. Thanks!
Abramo,
Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Many thanks for letting me know about forum posting rules. Have now started a new thread as suggested.
http://www.excelforum.com/excel-prog...76#post3238076
Worked perfectly, thanks Donkey0te!
Could it be done using formula rather then macros?
see post #8
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks