Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Concatenate problem
Ooops...wrong group. I was thinking Access. My bad. Your solution may be
somewhat similar however. "Steve Schroeder" wrote in message news:... Write a function that accepts the ID as an argument, then open a recordset using it as the criteria, loop through the records, and concacetenate, store in a string, and update another table with the concacentated string value. Here's something I did awhile back: Function sCostDesc(lcindex As Variant) As Variant Dim sReturn As Variant Dim Db As Database, Rs As Recordset Set Db = CurrentDb() Set Rs = Db.OpenRecordset("Select * From cDescript Where cindex=" & lcindex & ";") Do While Not Rs.EOF sReturn = sReturn & " " & Trim(Rs![cddesc]) Rs.MoveNext Loop sCostDesc = Trim(sReturn) End Function "tmwilkin" wrote in message ... Hello, I'm working a file with two columns of data. The first column is an ID number, the second is a description keyword. An example is shown below: 388643 WSPHD170440 PE170IP4 417IPEB 388643 LIPE170IP4 IN004PE170IP4 388643 ZZFAB 388643 VVFL 388643 VVNW 766220 IN004!PE110IP5 766220 VVWV I want to concatenate the keywords for each unique ID into one row/cell (col B). Can anyone assist? I can work with any function that generates duplicate rows as I could strip them out later. Thanks in advance, Todd |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
concatenate problem | Excel Worksheet Functions | |||
Concatenate problem | Excel Discussion (Misc queries) | |||
CONCATENATE problem | Excel Worksheet Functions | |||
Concatenate Problem | Excel Discussion (Misc queries) | |||
concatenate problem | Excel Worksheet Functions |