semicolon

Hi! I am using Excel in Germany, with German locale settings. I have met with a very odd behaviour from Excel: When I write the formula for calculated columns I use ";" as separator (as for any other Excel formula) between the arguments. The Formulae are working fine, everything is tip-top. But...

Hi everyone, I came across a problem with the task currently at hand: I need to save a file as .csv with a semicolon as separator. My Windows regional settings also have a semicolon as list separator. When I manually save the file as csv (or even manually save a macro generated .csv before...

Hello everyone. After running a query in SQL Server 2012, and copying the results with headers to Excel 2013, I have some cells containing semicolons that are inserting a new row. For example, if the cell has a value of patient copay 81234567, when pasted into Excel it is shown as patient...

I am hoping I am on the right track, but the formula below does not work when entering this in custom data validation. I am attempting to create a code that will notify the user if they have entered multiple email address's in one cell without separating them out with a semicolon. I have...

Hello I am trying to write a vba-code which will save my Excel file as a semicolon separated values file. Unfortunately my results so far are halting. Both pieces of code below create a semicolon separated values file, but only if I save them manually. If I just close the worksheet the file is...

Hi, I am using Excel 2007 in windows 7 I would like to delete values within a cell which are separated by semicolon. Eg <colgroup><col><col></colgroup><tbody> <colgroup><col style="width:48pt" width="64"> <col style="mso-width-source:userset;mso-width-alt:3181;width:65pt" width="87"> <col...

I have a problem with the text import wizard while importing semicolon delimited files. I get standardized files from my suppliers with product data and prices, in form of a semicolon separated text file. The problem is that sometimes excel doesn't recognize the semicolon as a delimiter, if it...

Hi, I have csv file. Normally in excel I select column "A" and can do -> text to column -> delimited >semicolon and everything will be done ok. I need to do it exaclty this same but in VBa. sub TEST Dim FileToOpen, sourceFile, outputFile As String Dim TextLine() As Integer Dim sourceWb As...

From another source I'm generating .txt with data in a string with records separate by semicolons and the two fields separated by a comma. 97,946;187,946;431,947;317,945;367,946;334,960; I thought this would be an easy import where record=row and the two fields each get their own col. But...

Hi, Please help me ! Few years ago there was some discussion on this forum (http://www.mrexcel.com/forum/showthread.php?134185-xlCSV-comma-Save-As-CSV-semicolon-delimited&highlight=csv+semicolon ) about the problem that I have but I hope that my problem deserves a new thread because it is...