comma

Hi I have a list of 4 digit numbers in a column in Power Query, for example: 1234 3827 3845 4028 3957 The file is refreshed with a new list each week with a differing amount of numbers. I want PQ to combine them so they end up in a single cell in the following format...

Greetings Excel Community, I have a set of data and i am wondering if there is code or formula that can be created to parse these values into comma delimited dates. The dates are combined together to make it look as a long string, however i am attempting to create the end result under the...

Greetings Excel Community, Below I have some Test data where the Unique ID has a relationship with the "Value" column. For each UniqueID, there must be a corresponding row from the "value" Column. What I am trying to accomplish is a formula or VBA Script that will split the UniqueID into its...

have the output in Column A. Want to get COLUMN B and C. How do i do it? A B C apple: RT, banana: TR, banana: DS, apple:PL apple: RT,apple:PL banana: TR, banana: DS need an excel formula

Hi all, I currently have a very messy sheet that looks like this: Essentially, row 1 is the heading, row 2-3 is the results that I want to produce through a text to columns, and rows 24-45 are the data that I currently have. The issue is that my cells have become messed up, so for every...

Hello. I need help with this issue. I need to add UNIQUE Value from the below cells comma separated unit there is an empty cell. This is required from product upload. I have bold the data which I need by VBA. After row 10 there is an empty cell. So the script will run from Row 3 - 12 and...

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, Is there a way to highlight duplicates in comma delimited cells that are in a column, I want to compare all comma delimited text values in every cell in a column and highlight the cells that contain the duplicate text, Can someone help with this please

I have a list of Email Addresses in an Excel File along with other columns. I Filter the email column to search for mistakes, like double periods (..) which works fine in the filter. But when I search for a comma (,) it's not allowed. Sometimes people type a comma for the period (by accident)...

Looking to list out all values for Column B that correspond to column A listed out in Column C at change in value of column A separated by a comma <tbody> Column A Column B Column C 100001 35 100001 64 100001 45 100002 64 100002 72 100002 74 100002 68 100002 59 </tbody>...

I need to include a Comma plus 1 blank space to come before a wildcard reference to a cell content with countif/countifs Here is how the formal looks without the comma and blank ", " added =COUNTIF(ref_name,"*"&$A1&"*") Is this possible?

Issue: Multiple duplicate values in excel cell. I have multi column data A to AA. In some cells I have multiple duplicate values in each cell (contains numbers and alphabets and special characters) separated by comma. How to remove multiple duplicates and keep only the unique values in each...

Suppose I have two numbers 8170.5999 618.111 Is there a formula that shows them as: 8,170 618 That is, show a comma when over 999 I used TEXT with "$0,000" but this shows the comma even for numbers below 1,000

I have a sheet that i want to import data to (sheet1 B2) this data is seperated by a comma i want to seperate and create it listed in a single column on (sheet 2 B2, B3, B4 etc) can someone please help with a formula thanks in advance

i have 6000 rows in my range, i want to add a comma to the 7 character location from end. i have this formula that i tested in a single cell and it works BUT when I try to apply it to the entire range using a With Range, the syntax is off (get mismatch error) can anyone assist with proper...

Need help..... I have 2 different cells having values separated by "comma" (,). result should appear in third cell as sumproduct of these two input cells. e.g:- 5,10 200,100 2000 (=+5*200+10*100) 1,2,3 50,100,150 700 (=+1*50+2*100+3*150) thanking you in advance,

Hi, I have a template that calculates costs for services per month based on input from managers. I have set dot/"." as default decimal sign whilst everyone else have comma/"," (applies to all excel files you open). Due to this, they can not see the calculated costs for rows that contain cells...

I am trying to put asingle text character al the way right when using "courier new" itlines up in he same place. The setup is: Name cell: Last, First Group cell: can be character two, three, or fourcharacters, and will be listed first Using FIND to get just the LEN of Last nameand comma...

Hello. I'm attempting to write code that will copy and insert-down rows of data based on however many times a "," appears in a string. I've already written a succesful 'Do Until' loop that copies and inserts down. I now need to go back to the newly inserted data and remove text before or after...

Hi, I have been searching without success for the following: I have a imputbox to receive euros, if the user wants to insert for example the number 55.20, afterwords I will use that number to do another calculation, but is giving me an error because its inserted with a dot as a decimal...