commas

I would greatly appreciate if anyone can help with a formula to extract the text before, between and after commas in the following: 5,6,31,3,1 or 14,3,24,2,14 there will be a max of 3 commas and 2 numbers separated by commas, so minimum of 9 characters and max of 14.

Hi, I currently have the following formula that looks at 3 cells and then pulls through up to 3 codes into another cell using a VLOOKUP and CONCATENATE function. The codes get pulled through fine, however if there are empty cells or the Vlookup should pull through a blank, then it's just...

I have a single column of values on an excel spreadsheet. The contents of each individual cell correspond to Gate Codes, and are inputted exactly like the red text below: example 1: 4 example 2: 4,6 example 3: 2,6,7 example 4: 5,12,1 Note: there will NEVER be a triple digit number - just 1-2...

using number separator (have commas) automatically wraps text vertically when using from the ribbon oddly, using currency, accounting, or even ctrl + 1 then clicking "sepators" doesnt do the same thing ...please help i even tried clearing the entire sheet's formatting then trying again but to...

Hello!! Is there a way to check if two commas exist in a cell? In cell H3 of my worksheet users will enter an address and I want to make sure they use two commas when entering an address as another sheet takes this address and splits it. for example: 123 ABC st Moraga CA 97501 should read...

What is the excel formula to be used in the following strings? I need to remove spaces and commas, etc. Ex. CC1994, 2 - it should be CC19942

I know there is a way to search for multiple instances of a value and return all of those instances separated by commas. I am wondering if there is a way to use VLOOKUP (or any other formula/VBA) to search for something like "English1,English2,English3" and return "Spanish1,Spanish2,Spanish3"...

In Excel, I want to format a number as "General", together with commas to separate multiples of 1000. The current General format excludes the commas. For example: INPUT: 1245.32 SCREEN OUTPUT: 1,245.32

Hi, Can someone please tell me how to replace certain commas in a string with a semi-colon? I do not want to replace any of the other commas. Example: = MIN(MIN(R67595,R250000), R67574)+ SUM(R27215,R27218) Should be: = MIN(MIN(R67595,R250000), R67574)+ SUM(R27215:R27218) The commas I want...

Hi all, Ive searched a few posts related to removing commas and Ive tried to adapt the answers to my situation with no luck so I am biting the bullet and adding to the forum fodder. Here is my situation. I have about 6k rows of text where there are single comas separating values and at some...

=IF(C10="01", "No Sub Project", IF(C10="03", "Sub Project 1", IF(C10="04", "Sub Project 2", IF(C10="05","Sub Project 3", IF(C10="06", "Sub Project 4", IF(C10="07", "Sub Project 5", IF(C10="08", "Sub Project 6", IF(C10="09", "Sub Project 7", IF(C10="13", "Sub Project 8", IF(C10="14", "Sub Project...

I've created a formula in excel that I'm using to reference as my horizontal axis labels. The equation is as follows: ="MedCode "&AO4&" $"&ROUND(AT4,0) Where the ROUND(AT4,0) is a dollar amount that is being rounded to the nearest whole dollar. This is how it looks on the axis: <tbody>...

Hi everyone, I guess I don't seem to understand the SUMPRODUCT function enough in terms of separation of arrays by a 'comma' or by a 'multiplication' sign. Here's my issue: I do not understand why when using SUMPRODUCT and a '*' (multiplication sign) to join the array calculations the formula...

Hi all, I'mhaving trouble using currency formatting in a cell with multiple values. Column B shows one figure, Column C shows another, and I'd like column D to be "Column B - Column C," but I'm having trouble retaining the currency formatting (e.g. the comma separators). I created a formula...

Hello In essence what I need is very simple but I cannot find an answer anywhere online. I have a long string of numbers of variable length (sales in a week) in a format where another number simply gets added to the string each week. I think I am right in saying I want to be able to find out...

How can I solve this problem? I tried recording a macro that finds all the blank cells (with F5) but that finds billions of cells. My code for the CSV exporter is currently: Sub NewCopyToCSV() Dim MyPath As String Dim MyFileName As String 'The path and file names: MyPath =...

Hello all, Currently I have written a macro that converts values in a cell to values mapped in another tab list. My code is: Sub DataFormatPR() Dim PremiumType Set PremiumType = Sheets("PremiumType").Range("PremiumType") For Each cel In PremiumType.Columns(1).Cells MainTemp.Replace...

I need a formula that will calculate the average from a list of numbers in a single cell. These numbers are entered as individual percent values, and separated by commas. An example would be: A1 = [55%, 60%, 7%, 92%] For the above example list, the formula I require would spit out 54%...

Hi all I'm using Excel 2003, Windows XP I'm trying to get rid of all trailing commas in a text string, for example: "Steve Smith,,,,,,,,,,," "Sarah Golding,,,,,," The number of trailing commas varies in a list of 500 names - I've tried a few formulas including these two...

I have a column that has multiple values in each cell separated by a comma (i.e. Z2_2,Z2_3,Z2_4). All of these are in sheet 1, column A I then have a reference sheet (sheet2) of products... (i.e. z1 - received as gift) in 2 different columns (A, B) reference table is B2:C261 . I want a...