semi-colon

  1. E

    VBA Macro to export a data range to a semi colon separated CSV file.

    Hello guys. I am new here and have tried to search for an answer that suits my needs, but to no avail. I have managed to do almost all I need it to do by copying functions from others suggestions here. Private Sub CommandButton1_Click() Dim content As String Dim rng As Range Set rng =...
  2. B

    Formula seperators

    I have just upgraded to office 365 for Business All my formulae now contain the semi-colon symbol instead of the comma symbol and I have to capture a formula now using the semi-colon. Is this a setting I need to change to continue using the comma? e.g. vlookup(A15, A7:C14, 3, false) now shows...
  3. T

    How do I separate a long string of emails with semi-colon?

    Hello, I have 1 Excel Cel (A1) with a long string of people email addresses without a bloody space. It's hard for me to insert this in Outlook without Outlook bombing out. The Cell is like this as an example: <tbody>...
  4. sharky12345

    Loop through Textboxes

    I have 5 textboxes on a userform and I want to evaluate if they have text entered. The values are used as a 'CC' list for an email message, so I also need a semi-colon added after each textbox. Can someone show me how this could work?
  5. A

    VBA Code for Excel to Replace Every Other Semi Colon

    I have a SharePoint list that I export into an Excel sheet. I run a macro that helps me quickly format this list into a printer friendly layout. I have one column though that includes the names of 1 to 6 people that I'm having a hard time formatting. If I have a single name in a cell, it appears...
  6. stefankemp

    ADO recordset returning only nulls

    Hi, I am trying to query a csv file using ADO. The procedure worked fine in the past, but I have recently received a new csv file that it doesn't want to read from. The only difference I can find between the old and new csv file is that if I open the old file in Notepad, the text just wraps...
  7. K

    Importing semi-colon separated file to an excel workbook

    Hello, Im very new to using the Visual-Basic Editor in Excel, I have been searching for a solution to my problem but could not find one. Ive got a file .skv type (semi-colon separated) that ive set to open with excel (I'm using 2000). I want the data from this file (5000 rows with 4 semi-colon...

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
Back
Top