comma

I want to introduce a number with COMMAS for decimals and I want excel to add "hours". For example, if I introduce 6 in a cell I want to see 6 hours or 6,00 hours, I don't care. Or if I introduce 6,43 I want to see 6,43 hours. Which format should I use to get that? Thanks!

I am working with a list that I am copying into Excel. I need the list to end up in a text file with a comma and a space after each record. After saving the file out of Excel into a comma-delimited file there is no comma after the records. Am I doing something incorrectly?

Hi, Is it possible to split a hyphen string into comma delimited. Example: From This <tbody> A1-10 J1D1_4-J1D1_7 C2, C4-C8, C12 </tbody> To This <tbody> A1, A2, A3, A4, A, A, A7, A8, A9, A10 J1D1_4, J1D1_5, J1D1_6, J1D1_7 C2, C4, C5, C6, C7, C8, C12 </tbody>

Currently using [bhos123] 's solution but I have to find and replace the commas that appear as I don't need them (commas also appear in column C) ; so my patched together combined macro works but it obviously can be better if I can remove the comma problem. [Kutools Advanced combine rows VBA...

Hi I have a question that I can't seem to find a working solution for In sheet #1 I have a list of ISSN numbers in Column A: <tbody> A 1 ISSN 2 0904-3535 3 0941-4355, 1433-7339 4 2076-0787 </tbody> And in sheet #2 I have the following in columns A and B: <tbody> A B 1...

Hi - I wrote the following code to be able to hit a macro button to format columns "J:M" with the "comma" format on all worksheets, but it doesn't work. When I click the Macro button, it highlights the columns but then doesn't format them. It doesn't error out either... What is my code...

Hi, I have a text string like the one below: France, Germany, Mexico, Australia, Croatia I am wanting to return the first 3 characters after the nth comma, i.e. Mex or Aus. How can I go about this?

Hello - Any guidance on the below formula? There are two IFERROR lookups but I it is not working or changes the comma before the second IFERROR to a * and that does not give expected results. TIA! =IF($N2="NS",$K2,IF(AND($N2="SB",$Q2="Y"),IFERROR(VLOOKUP($T2,'PCP Contractual...

Using VBA is there a way to replace carriage returns with a comma space? Also, if the value ends with comma space or comma i''d like to delete those value. This will be done on sheet called Cranberries in coulmn E only. EXAMPLE <tbody> CURRENT WANTED RESULTS APPLE JUICE GRAPE JUICE...

Hi Guys, Apologies in advance if my post is not formatted correctly as this is my first question - this is a simple question that seems to have a complicated solution. In my spreadsheet I have 1540 book titles for each book title I have multiple subjects, e.g animals, children etc. I want...

Hello. How can I get this to include a comma for 1000's please? 0.0,;[Red]-0.0, eg 1,100.0 instead of 1100.0 Many thanks

Hi Guys, Really looking forward to your help with this one. I needs to combine cell data and have a comma spacing between them. however I don't want empty cells to merge. For example, <tbody> 1. Apple 2. Tomato 3. Banana 4. Apple 5. Apple 6...

Hello, I've found a few formulae to do close to what I'm looking to do. Short story: I have a report that pastes into an excel "tool" that then digests information and merges it into a word form via mail merge. It generates as many as 1000 forms per day, so it's important to get things...

Hi, I created the below sub to convert a single column of values (of varying amounts) into a single, comma separated string. Thus if Column A on "Sheet1" contains: 50 55 60 65 70 75 The procedure will convert that to a comma separated string on a new worksheet ("List1"), e.g.: 50, 55, 60, 65...

I currently have and use some code that exports a range as a CSV. It has done everything I need up until now. I need to export data that contains commas. I need to export the data as a .CSV for the next step of my operation, but I need it delimited by something other than a comma. Does anyone...

I have a cell that contains a full address e.g. Flat 10, 1 London Road, Bromley, Kent, BR1 1AA. I would like to be able to extract each of the parts of the address that are seperated by a comma. I have managed to get the first line with: =LEFT(A1,FIND(", ",A1-1) And the second with...

Hello. I have a bit of an issue. I am trying to combine a first name and last name with a comma in between. For example, I need Jane Doe to become Doe, Jane. Cell C1 is Jane Cell D1 is Doe I have used these formulas: =D1&","&C1 =CONCATENATE(D1,",",C1) In both cases the result is: Doe...

Got names in column F, written like: Lennon John Winston. Column holds headers. Anyone that got a vba that can run through column F and add comma after the first word? When name is Lennon-Smith John Winston the comma must be placed like this: "Lennon-Smith, John Winston". Tried this...

Hi there. I'm trying to reformat a number as follows. 101,015.15 should show as follows 101.015,15 with the decimal and the comma reversed. I was able to change the first comma to a decimal with custom number formatting, but can't seem to change the second period. Can someone send me the code if...

I had some comma separated vallue in a columb, like below: A,b,c d,e,f i want to make it like: A b c d e f