separated

Looking to list out all values for Column B that correspond to column A listed out in Column C at change in value of column A separated by a comma <tbody> Column A Column B Column C 100001 35 100001 64 100001 45 100002 64 100002 72 100002 74 100002 68 100002 59 </tbody>...

I have a bunch of data that looks like this abc, def, 123, ghi The lengths of each string aren't consistent line over line. If an entire worksheet was like this I'd just go to Data/CSV and open it like that but this is just a small range. How would I separate values that are currently...

Can someone explain why adding hyperlinks before adding validation switches from "," to ";" which is default xlListSeparator? Sub test2() a = Join(Application.Transpose(Selection.Columns(1).Value2), "; ") Selection.ClearHyperlinks Selection.Validation.Delete...

Hi Guys, I receive a list of items pertaining a customer. I want to do is check if list A has an item from list B then create list C. The problem I’m having is that list A is all in one cell separated by a carriage return. So for example cell A3 has xxx xxy xxz, and can be up to 40 items. I...

Hi, Is there any way that I could return the value in a range with given certain condition. For instance: <tbody> Name Class Score Ali A 89 Alvin B 78 Barry C 23 Cynthia A #N/A Derry C 77 Kalvin B #N/A Ricky A 68 If Less Than 80, Name Class Score Alvin B 78...

hi friends, I have the following txt strings that are not delimited and I would like to have the data separated 0120190624INIT 99999 0312345678920190621AB 000000000000000000 000000000000000000122365ABC 0310111213120190621AB 000000000000000000...

Hello, Is there a formula to combine cells on the same row (A2:H2) with each value separated by comma and one space ignoring any blank cells? Thank you

Hi I want to get live data from a buoy which come in the form of an online text file (it can be seen by clicking on the link below). I want to import this data and end up having only the data separated properly into their respective columns etc. Is this a power query job or VBA job...

Using Excel 2000</SPAN></SPAN> Hi,</SPAN></SPAN> Data in columns C:P, need to count "0" and "1" in a single cell separated by vertical bar in the column R </SPAN></SPAN> Example data</SPAN></SPAN> Book1ABCDEFGHIJKLMNOPQRST12345P1P2P3P4P5P6P7P8P9P10P11P12P13P14EMCount 0 And...

Hi all, New to the forums, keep up the good work. Getting stuck on getting a cell with a value of 1-10, separated out into its individual values i.e 1,2,3,4,5,6,7,8,9,10 Another example is 50-60 again, i want to separated the values out like: 50,51,52... and so on... Can anyone help? I...

I have a table with multiple values in the same cell separated by commas. I also have duplicate values within the cell. A1- 0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19 B1-19,2,1,0,7,8,9,5,13,20,21,22,23,24,66,77,11,12,14,44,32,26,27 now i want duplicate numbers from...

Hi, I need a script that takes an InputBox entry separated by commas then form number combinations of two from the data entered. The InputBox will always take a maximum of 5 numbers separated by commas. Example "00,01,02,03,04" And then form all the combination of two : "00-01" "00-02" "00-03"...

Hi, I'm wondering if there's an easy/automated way to make multiple strings of data from a large data set. The thing is i would like to use information in another cell to determine when a new string should be created. The issue that I'm having is coming up with a formula, or logic, to use a...

I have a spreadsheet with thousands of lines but I will just show one line because each row is independent. For the life of me I cannot figure out how to format the example in this message space, so I put a public link to a Google Sheet, but I am using EXCEL for the actual spreadsheet not...

Hello, I got 4 different scenarios Seenario1-in column C got 2 number separated by vertical bar with Seenario2-in column E got 3 number separated by vertical bar with Seenario3-in column G got 4 number separated by vertical bar with Seenario4-in column I got 5 number separated by vertical bar...

Hi everyone I want to extract all the numbers from a string and get them separated by columns or at least separated by comma for example the person left the cellphone 45213204456, job 3489334 house 9888234 mother 452103210, value to pay $25 result <tbody> 45213204456 3489334 9888234...

Good morning Wondering if it is conceivable to search if a cell contains "PO" "PO1", "PO3" up to possibly "PO8" in a string and return the data on the left which will be separated by a space. Ex. Northwest 654 PO1 ID236 The "PO" is not in the same position in all cells. Thank you

Good morning Trying to extract a string of numbers, could be up to 20 values which are separated by a column into individual cells in same row. Formula would be beneficial. Example 1, 2, 3, - export as 1 2 3 separated. Thank you

Hi I have a challenge where I have to compare the coma separate values from 2 columns (Column A , Column B and find the sequentially comma separated matching values and output to Results column. Example: Compare "Column A" values (Coma Separated ) with "Column B" (Coma Separated) and output...

Hello. Very new to VBA (very new). I have a spreadsheet with three columns and need to do some work in the last two columns. [Sheet 1].[Column A] - ID [Sheet 1].[Column B] - BUILDING [Sheet 1].[Column C] - DESC <tbody> ID BUILDING DESC A L1 L2 Very Large Extended B L1 L3 L4...