moving similar text into another column

[sandrikoti]

Hey! Here in the attachment that I uploaded is the problem given. The first sheet of the excel document indicates the starting position, so to say, and the second sheet is the result I want to get. So, if an A column contains similar texts in different cells I want that text (in this particular case "woman") moved into different column (not changing the row number) grouping similar text into columns.xlsx

[Ali Kırksekiz]

As for as I know, These code belong (Alphafrog)

To install the custom function...
Alt+F11 to open the VBA Editor
From the VBA menu, select Insert\ Module
Paste the code below in the VBA Edit window

Please Login or Register  to view this content.

Sheet2 C2 cell

Please Login or Register  to view this content.

pull down

[sandrikoti]

any help? ...

[Ali Kırksekiz]

Check sample file.

[sandrikoti]

what is the VBA Editor? should I install it? I've got Microsoft Visual Basic - same thing?

[Ali Kırksekiz]

what is the VBA Editor? should I install it? I've got Microsoft Visual Basic - same thing?

http://www.homeandlearn.org/the_excel_vba_editor.html

[sandrikoti]

Ok. I added VBA feature from the disc, I hadn't installed it then. But now I got another question, the thing is, I need to indicate THE WORD I'm looking for or the column I want to replace THE WORD from, because that example (about "woman") was just made for clarification. What can I do about it?

[sandrikoti]

there is another way, though. suppose all the WORDS I'm looking for is in column H - I want to find the word "own" and place all of them in column G. just like in the attachment for example