comma delimited

  1. H

    inserted commas, now need to separate

    I used this formula to insert a comma after the first text in a column (last name in this case), =REPLACE(C2,FIND(" ",C2),0,",") and worked like a charm. Now I need to separate the last name and first name in to two columns, but the column with the new commas is actually full of the formula...
  2. J

    Write selections from Excel listbox to cell?

    Hi everyone, I would've thought this was a simple enough question but I've been searching online for an answer all week, including on this site. I've seen answers that seem to be close to what I'm looking for but when I attempt to extrapolate and modify the code I get nothing but error...
  3. R

    Make comma delimited list from column data using search criteria

    If I have the following data in two columns, I need VBA code that creates a new table that finds the data associated with A,B, or C and then lists it as comma delimited text -- It's kind of like a sumif in Excel except that instead of adding numerical values, I need to create a list of text...
  4. N

    Trouble with .CSV file

    I am working with a .CSV file that is generated upstream from me. It contains 1500 rows of data, each row has 6 columns. The first column is "Company Name", followed by three columns of dates and then some performance numbers. The problem I am having is that the file is comma delimited and...
  5. Gingertrees

    change (x) rows of data into a comma-delimited list

    I have a section of my sheet that allows the user to put in household member names, one member to a row. (In the other columns in each row they enter the members' demographic info.) How can I turn a VARIABLE number of rows of names into a list in a different part of the sheet? So for example...

Some videos you may like

This Week's Hot Topics

  • Launch Script When Tab Is Opened
    Hello all! Is there a way to launch a script or message every time a particular tab (DATA1) is selected/opened? I know it can be done when...
  • VBA that can extract words that starts with # and ends with 2021.
    Hi Everyone, I am straggling to in searching for a vba code that will extract a string that starts with # and ends with 2021. The string has no...
  • Date update overflow error ‘6’
    Dear MrExcel community, I have a project search & update & add & delete can do. There are 32 column and 5 of them is date. When I search date...
  • VLOOKUP Formula ?
    Hi i am using this below but i need to return Column C on Detailed_view. You can see ,1 this returns D, but i need to return C before D. I tried...
  • conditional formatting the whole row
    Hello This is a question solved earlier by etaf. But I am getting some problem. I need help to correct the formula as it is not working in some...
  • Vlookup in vba
    Hi, I am new with the VBA, can someone help me, I have made this macro, but the loop across files in a directory runs only in cell G13, and I...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top