semicolons

I have tried several formulas from this forum, but I cannot get what I need. I have a long spreadsheet with over 1000 values.... One of the columns....columns AC contains the following string....this is just an example... These strings are not fixed. There could only be one value or...

Hello, So, I'm working with numerical codes and some of them are separated by (;) and some are not. When I exported the file for some reason there would be 15 semicolons attached to the codes. I would like to remove the semicolons at the end of each number but need to keep the ones in between...

I use this code to write to a txt file: Dim rCell As Range Dim rRow As Range Dim sOutput As String Dim sFname As String, lFnum As Long 'Open a text file to write sFname = "\\SERVER\Company\FÖRETAGEN\RTFL Care AB\Tidrapporter\" + Range("e3").Value + ".txt" lFnum...

Hi all, I have a macro where i'm trying to convert an excel file to csv with semi-colon separator. I thought the method was to convert to csv, and secondly to replace coma by semi-colon but it's not working. It seems we can force the separator somehow, but I don't know how to do it inside my...

Hello Everybody, I have an Excel-sheet, which I want to save as csv-format. I need the columns to be delimited by comma, however when I save the file as a csv-file, the columns are delimited by semicolon instead. How can I change this? Thank you in advance. Best regards Jan Hoffmann

This is frustrating me! I want to create a data validation list where some of the entries contain a comma. So I do like this: which gives me what I want, namely entries containing commas: I save the file and everything is fine... until I reopen it again. Then I see this: and when I go...