separator

I would like to know if there is a formula to make a numbering format standardised. I have a work sheet, with a column that contains data similar to below: 45-02-001 45-02-002 45/02/003 45-02-004 45/02/005 45-02-006 Some of the fields separate the numbers with "-" and others with "/" (due to...

Hi, I have a data set in the html page looking as table containing numbers, dates, times, strings etc. each in separate column. I'm trying to copy this data set to excel and format it as I want with VBA. The only problem I have is that the source data set is using DOT "." as decimal separator...

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...

Hello Everyone! I have a question about List Separator, so it is possible to change list separator via vba code? I know the decimal can be changed via vba, but I didn't found anything about list separator. Thank you for help!

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...

I want to automatically delete the thousand separator in this value. Can someone pls. help me with a Excel formula? 1.500.00

Input:C1 Mary went down the and hurt her head D1 hill Desired Output: Mary went down the hill and hurt her head Below is the best what I can describe the logic as: (If C1 contains "keyword") (Separator " ") concatenate [D1] as "[C1...Keyword][Separator][D1] [Rest of C1]" Below is the...

Hello, I want to combine 2 cells with numbers and keep the thousands separator. A1 = 1.500 B1 = 3.000 Result in C1 with =A1&" - "&B1: 1500 - 3000 I want the result look like this 1.500 - 3.000 Is this possible? Thank you.

Greetings, I am receiving an "expected: list separator or )" on the following line. C = PA.ws.Range(Cells(D, "A"): Cells(G, "A")).Rows.Count I am trying to set an integer variable for a range of cells defined by other integer variables. Where is the error?

This is giving me an error Worksheets("Sheet1").Range("A" & i&":B" & i).Cut Compile Error: Expected List Separator or ) please help

Can anyone explainto me what is wrong with this Formula. =SUMIFS(F760:F841,B760:B841,"A",I760:I841,"B",J760:J841,"C",K760:K841,"D") On a worksheet it works without issue. When I try it in VBA it gives the following error. Compile Error: Expected: List Separator or). The colon between F760 and...

hi all... i'm looking for in Custom Number Format to determine number with separator hundred, thousand, million and billion in Indonesia Format.. mark dot (.) is not decimal but separator Excel 2007FG5datacustom...

I would like to be able to select different cells, like A4, B2, C1, E5 and have them concatenated in 1 cells whereby I am asked for separator to be used, like space, or comma, or semi-colon separated So, instead of manually adding " " each time in =CONCATENATE(A4, " ", B2, " ", C1, " ", E1)...

Dears, How can I do the following "number formatting" using VBA: If I write, 118.25; the system will write 118.25 If I write, 18.25; (without the first 1) the system will write 118.25 If I write, 11825; (without the decimal separator) the system will write 118.25 If I write, 1825; (without...

Dear, I would like some help on the formulation of a formula in Excel in order to compare the total number of search results upon using different sets of separator characters. As I have multiple columns with content, as in the example below, I thought it would be possible to Count the...

Hello! I'd like one of my workbooks to have a different decimal separator than usual. my system (spanis) uses "," as decimal separator, and "." as thousand separator. I'd like one of my workbooks to use the oposite, (the usual english format, ".2 as decimal and "," as thousands; but only this...

Hello, I have data listed in a worksheet that contains text in the first column that needs to be replaced throughout the entire workbook. The data looks similar to this: Sun, $D$8#Home, $B$42#WWB, $B$3#Definitions Earth, $D$18#Summary, $B$3#Page 1, $B$42#Classroom Ball, $E$27#Home, $B$4#WWB...