Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro - searches for key word in a column and concatenates entire
Let's say i have a column A and column B with a lot of cells with different
content. For every cell in A column with content , there is a B cell with content What i want is macro which searches for given key word in column A . If it finds it , it concatenates entire row (without spaces between content of different cells) and puts in in column C ( let's say ) The most important thing is where it puts it . And i give in example : key word : house A1 : garden B1 : basement A2 : house B2 : bedroom A3 : mother B3 : father A4 : house B4 : like a cottage Finds keyword in A2 , concatenates A2-B2 ( result - housebedroom ) and puts it in C1 ! Finds keyword in A4 , concatenates A4-B4( result - houselike a cottage ) and puts it in C2 ! so on ... In my case , as i said before , i don't need spaces between content from different cells . For what i use it , the concatenated result makes sense without spaces |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
alphabetize entire rows by first word of first column | Excel Discussion (Misc queries) | |||
Need macro that concatenates cells with text | Excel Programming | |||
change first letter of a word for an entire column | Excel Discussion (Misc queries) | |||
How can you write a formula that searches for a particular word? | Excel Programming | |||
Getting valid web searches and avoiding sites that contaminate web searches | New Users to Excel |