How Do I Group Similar Keywords

malverd

New Member
Joined
Jul 28, 2010
Messages
15
Say for instance I have keywords in cells A1 through A500 sorted alphabetically A to Z. Cell A1 contains the words 'knife blades'. I want to be able to select cell A1, copy, then have a function or macro that allows me to paste the word 'knife blades' and similar words into another group of cells,

example:
knife blades
knife blades for hunting
knife blades for the kitchen, etc.

Thanks
 

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.
You could use Data -> Filter -> Autofilter
Click the drop down arrow
Choose Custom
In the pop up window, where it suggests "Greater than" down in the list you will find "Contains"

Filter the list, copy and paste

Will that solve it?
 
Upvote 0
This is actually what I meant to post. Not how I changed the structure of the list I would like returned. Thanks.

<!-- / icon and title --> <!-- message --> Say for instance I have keywords in cells A1 through A500 sorted alphabetically A to Z. Cell A1 contains the words 'knife blades'. I want to be able to select cell A1, copy, then have a function or macro that allows me to paste the word 'knife blades' and similar words into another group of cells,

example:
knife blades
sharpest knife blades
best knife blades, etc.
 
Upvote 0
Given that A1 is the word you want to copy+paste
Given that B1 is the word you want to paste onto

Then

In Cell C1,

=B1 & A1
 
Upvote 0
Basically I want to find all instances of knife blades and have some sort of function or macro that would allow me to do that.

Here is a link to a video that explains what I am wanting to do.

I already emailed the person that made the video, but haven't heard back from him.

The information I would like to find out starts at about 2:13 into the video

http://www.robdogg.com/wordpress/swf/kclustering.swf

Thanks
 
Upvote 0
BrainDiesel

Thanks, that is close to what I am looking for. Instead of 'contains' I chose 'ends with'. Is there a way to automate this (macro?)

Thanks again...
 
Last edited:
Upvote 0
Any more solutions for this one? I was looking to create a macro I think. I'm not that good with Excel, and was hoping for an expert here.

Thanks
 
Upvote 0

Forum statistics

Threads
1,217,440
Messages
6,136,636
Members
450,022
Latest member
Joel1122331

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top