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
 

Some videos you may like

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

braindiesel

Well-known Member
Joined
Mar 16, 2009
Messages
554
Office Version
  1. 365
  2. 2019
  3. 2010
Platform
  1. Windows
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?
 

malverd

New Member
Joined
Jul 28, 2010
Messages
15
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.
 

kpark91

Well-known Member
Joined
Jul 15, 2010
Messages
1,582
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
 

malverd

New Member
Joined
Jul 28, 2010
Messages
15

ADVERTISEMENT

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
 

malverd

New Member
Joined
Jul 28, 2010
Messages
15
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:

malverd

New Member
Joined
Jul 28, 2010
Messages
15
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
 

Watch MrExcel Video

Forum statistics

Threads
1,122,694
Messages
5,597,571
Members
414,157
Latest member
MrBJBones

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
Top