| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
compare the first column and concatenate the second column
Hello, My original worksheet is like: ColumnA ColumnB Category Code Keyword BEQAB HAMILTON BEACH BEQAB HAMILTON BEACH BEQAB 00756|VITA MIX BEQAF TOMLINSN BEQBBP K7003NF|REGAL BEQBBP K7001NF|REGAL I want to get a worksheet like: ColumnA ColumnB Category Code Keyword BEQAB HAMILTON BEACH|00756|VITA MIX BEQAF TOMLINSN BEQBBP K7003NF|K7001NF|REGAL Is there any way that I can do it? Thank you very much! Best regards, -- George |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| =RIGHT (function) | Excel Worksheet Functions | |||
| concatenate cell and referncing afterwads | Excel Discussion (Misc queries) | |||
| Help with a formula for concatenate and search/find with 3 columns | Excel Worksheet Functions | |||
| If Statement and Concatenate | Excel Discussion (Misc queries) | |||
| Concatenate two halves of a phone number | Excel Worksheet Functions | |||
Linear Mode
