comma

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

I want to extract text before a comma, or space or if condition 1 or 2 is not met return text in cell: Example: James, John Jones Tom Lily Expected result: James Jones Lily =LEFT(A1,(FIND(" ",A1,1)-1)) extracts text before space =LEFT(A1,(FIND(", ",A1,1)-1)) extracts text before comma...

Hello OMG What i face now is when values displayed in formula bar as 200600 it displays as 200,600 in cell instead of 2,00,600 ie incorrect comma placement Following values 4,14,180 to display as 4,14,180 it displays as 4104,180 3,18,600 to display as 3,18,600 it dispalys as 3108,600 17676.40...

Hello, Is there a formula to combine cells on the same row (A2:H2) with each value separated by comma and one space ignoring any blank cells? Thank you

Hi I wonder if anyone could help me with a simple formula to copy all/or part of Cell (A) contents to cell (B). In column (A) I have several hundred rows containing random length alpha numeric text strings which may contain a comma. I would like a formula to copy all of the cell contents to to...

Hello. I am seeking how to add a comma to this formula {=CONCATENATE("and ",SUM(S2:S500)," in total Media Value")} so that a comma separates the thousands place in this result {and 1862943 in total Media Value} Thank you in advance for your help on this.

Hello, When i use FORMAT PAINTER on a cell with formulas on the next cell under =A2& " "&B2 so i can connect 2 columns A2 and B2 together with a space (it doesn't matter but i use alt+tab not space to show one under another) i want to copy paste this into browser or anywhere alse i get this...

Hello I have a big data file in excel with some 'weird' numbers for example: <tbody> 4959,68,4611,9 </tbody> Sometimes it's like this: 7500,7152,22 How can i remove the last commas so that only the first comma will stay? Thanks in advance Regards Wout ****** id="cke_pastebin"...

Hello, I have test equipment numbers in separate columns. How can I combine them into one column with the numbers separated by commas and one space after each comma? Note some columns don't have numbers. Thank you Excel...

Hi, I have columns with values a b c d etc, and i have to bring them all to one cell with a comma(,) after each of the values in the cell. Please help on this. Regards, Nik

Hi all I need to gather numbers from different columns of each lines into one cell ( for each line) in the following format, I am not succeeding with the engineering format and the counter 1.1,2.1 ,etc : 1.1,2.393e+00, 1.019e+01, 1.560e+00, 2.821e+00, -2.505e+00, 4.428e-01 2.1,2.393e+00...

Hello The helper or guide for excel no longer appears. For instance in the past I would be typing code and a "helper" would pop up. In a module, If I entered Columns. a drop down box with all the available choices would appear. Or if I entered Columns.Find( the properties needed for each comma...

The first column contains last name, while the second column contains first name. How can I merge the two columns and seperate the two names with a comma? Thank you

Hi all, I am having a minor issue with a function for concatenating a range into a comma seperated list. The function is as follows: Function ConcatUniq(xRg As Range, xChar As String) As String Dim xCell As Range Dim xDic As Object Set xDic = CreateObject("Scripting.Dictionary")...

<tbody> Coordinates Latitude Longitude 3.321151, 101.575798 Formula to Seek Only Before Comma Formula to Seek only After Comma </tbody> Possible ?

Hi I want to find all my dots in my excel sheet and replace them with Comma. I used the macro recorder to try to find a way and got the code below. However it doesnt work, if I have a number like 12345.6789 it will turn to 123456789 after the macro. Anyone knows how to fix it...

I have several cells, from F2 thru AU2. I'm trying to merge these cells into a comma seperated list in one cell. However, some of the cells are empty. Is there a way to do this?

Dear Sir, I want to insert comma (,) in the number like as standrad format of amount. In standrad format 1 million write as 1,000,000.00 but I want to write 10,00,000.00 ( this comma sepration is done in Nepali Amount). First Comma is inserted after 3 digit like as Standrad Format (English...

<code style="box-sizing: inherit; margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera...

I have a table that I have names in column A then inside column G are numbers. Column A is in range A17:A25 then G is also G17:G25. So in cell A16, I want to get all names that have values greater than 10 in column G. These names should be separated by comma. And if only one exists then no...