comma delimited

Hi I have a list of 4 digit numbers in a column in Power Query, for example: 1234 3827 3845 4028 3957 The file is refreshed with a new list each week with a differing amount of numbers. I want PQ to combine them so they end up in a single cell in the following format...

Greetings Excel Community, Below I have some Test data where the Unique ID has a relationship with the "Value" column. For each UniqueID, there must be a corresponding row from the "value" Column. What I am trying to accomplish is a formula or VBA Script that will split the UniqueID into its...

Greetings Excel community, I have a set of ID's and dates which are associated to these ID's. The ID's are repeated but there are numerous dates associated with its respective ID. What I am attempting to accomplish is combining all the dates associated with the specific ID. For example, ID 123...

Hello Excel Community, I have a weird request which I am hoping someone might be able to provide a solution. I have rows where dates are provided in the following format yyyy-mm-dd and contain multiple dates in that format (Example: 2023-04-062023-04-072023-04-08). What I am trying to...

In a single structured value I managed to count using below code Dim LastRow as long, eWan as integer LastRow = 136 eWan = 3 Lr0W = 10 iLOOP = 2 Do While eWan <= Lr0W Cells(eWan, iLOOP).Formula = "=SUM(COUNTIFS('DREC'!$A$2:$A" & LastRow & ",$A3,'DREC'!$B$2:$B" &...

Hi All, I have a table with tags separated with commas for each row like below: Date Item No Tag 1/3/2022 1 Tag1, Tag2, Tag3 1/5/2022 2 Tag2, Tag4 1/8/2022 3 Tag5 1/3/2022 4 Tag1, Tag2, Tag5 1/6/2022 5 Tag7, Tag11 1/3/2022 6 Tag1, Tag11 1/5/2022 7 Tag2, Tag8 1/4/2022 8 Tag1...

In my excel sheet, I have data like "","2,878","-51","58","202.89","3,935.80","40.65","50","3,910.95","3,927.95","50","14,250.00","5,050","0.40","0.45","7,400","0.10","0.40","106.60","2,665","-28","8,595","" I want to delete the comma within the number, for example in the above example the...

Hi Guys, I am trying to import a .txt file that will have comma as a delimiter. However one of the fields has a comma (that is not a delimiter) in it. For example 'Cleo will sing, and play the banjo.' I have code that imports it but then it puts the 'and play the banjo' into the next field...

I have a text string that I need to separate out via formula. I know how to do it via the built in Delimiter, but I have to do this via formula. VBA is an option too .... The sub-strings are delimited by a comma and a space, e.g. ", " The individual sub-strings can range from 2 characters to 3...

I have a table that has a list of requirements from various documents. The table is called "Combined_Req". Each requirement is assigned a unique identifier "ID", that is in the form of "CR-1", "CR-2", etc." I have another table called "Req_by_Category" where I have consolidated like...

Hello, I'm wanting help with add comma in last text <tbody> Column A (Original Format) Column B (Need Add Comma at last text as below) <tbody> ECJ1VB1H562K,F1H1H562A013,F1H1H562A748,F1H1H562A219 F1H1H562A842,F1H1H562B047 </tbody> <tbody>...

Need to figure out the formula to split cells using "Text to Columns", using the "Delimited" option for Original Data Type,the "Comma" option for Delimiters, and the "General" option for Column Data Format. Or find faster way to accomplish task without clicking through it. Thanks! :):):)

I have a row of data from B3:B11. Each cell contains a list of names seperated by a comma. To make things more complicated though, the names are grouped by department. For example, the text in B3 looks like this: <tbody> All: John Smith, John Smith, John Smith LOB: John Smith, John Smith...

Hi All, My colleague and I have created some VBA code to transform a standard report into semi-colon-delimited data, all within column A, which is then imported into our financial systems (SAP). SAP only handles numerical values in European format, therefore, as part of the transformation, we...

Hoping someone can help me with a function. I want to return the number in the left column that corresponds to “99292” in the middle column. I know I can use the “find” function to find the position of 99292 in the middle column, but that doesn’t correspond to anything meaningful in the left...

I currently comma delimit using this and put it to the clipboard using MSForms.DataObject Dim ConvertComma ConvertComma = Join(Application.Transpose(Selection.Value), ", ") Dim clipboard As MSForms.DataObject Set clipboard = New MSForms.DataObject clipboard.SetText...

Hello There, I have a big excel sheet with data in many cells across rows and columns: X Y Z X X Z T V V Z V V What i wanted to do is generate a list of cells with count as V 4 Z 3 X 3 T 1 Y 1 Can someone point me in the right direction, thanks.

I will have column information that will list entries like this: DD, DD9, SD, LHR, HIGHLIFT BOTTOM SECTION, DD, D9 DD, PVC DD, SD, LHR, HIGHLIFT Is there a way to run a SUMIF or other formula on these and separate the values from the commas? I am familiar with Text to Columns but I will be...

Hello, everyone. Thanks for taking the time to read my post and to try to help. I have one column of comma delimited names (ie, "Bill, Sue, Carla-S, Dave") that I would like to search against another pair of columns -- one that has a single name per cell, and its neighboring column with an...

Hi all, I have created a table of names on Sheet 1 called 'List'. On Sheet 2, I have created columns 'Task' and 'List'. I would like to choose multiple names in the list column drop-down and have them concatenated separated by commas in the same cell or an adjacent cell. Is this possible? How...