comma separated list

I've just hit a wall here and my brain refuses to bring this information up. I have a cell with a series of room names in it, separated by commas: Master Bedroom, Master Bathroom, Laundry Room, Stairs, etc. Call this A1 In "D1" I'd like to place a formula that will take those room names and...

I am not sure what the best course of action would be and if Excel and/or Access would be the best way to handle these issues. I have two text files each contain a string of ID values separated by commas one file is the "MASTER" list and the other is the "Exception" List I am looking for a...

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>...

I am trying to extract numbers from a comma delimited list using excel function/or VBA code The data looks like this: 1,55,,Private Information #1 for UB,After 56 seconds, your private estimate is that the final value will be $51.19 If the above data are in cell A1, I want to retrieve UB in...

Hi I'm looking for a vba solution for the following: Sheet1 Col A: Group Name Col B: list of comma separated terms (for this Group) Sheet2 Col A: text string Col B: Group Name I need to loop thru all the Groups in Sheet 1 and check if any of the terms in Sheet1 ColB...

In MS Excel, a List of commas separated numbers In a column, I have a text string number list ( up to four numbers) that represent row numbers in a table ( 'MyTable' in another worksheet). These numbers are entered by a user, that looks like the example list below: 23,234,2,16 The Goal using...

Hi I have a list of student needs (comma separated) in one column, with the rank of those needs (also comma separated) in another column, but the problem is, the rank is not always in a logical numerical order: <tbody> Column A Column B ASD, SEMH 1,2 SEMH, MLD 2,1 SLCN,SEMH,ASD 2,1,3...