turn

So, I have a column with rows like: 445 333,678,23 21,34 6 345,20 ...and I need to delimit all those with the comma, and make a single column somewhere else like: 445 333 678 23 21 34 6 345 20 Rather not turn to VBA...probably an array function where you shift+ctrl+enter ? Thanks!

Hi, i would like to create a vba code so that to turn decimals into integer number for col. "K" and "N". e.g.: 0.5 convert as 5.0 0.2 convert as 2.0 Thanking you in advance

I'm not sure this is possible. Maybe VBA? Ex 1: I want to select A3 (Turn Down Ratio), B3 (Number of sets), and C3 (Full Scale). Then in column E it will divide the Full Scale into 5 sets by the Turn Down Ratio in A3. Then shown in Ex 2, if I change the Value in A3 and B3, it will then...

No biggie here. While some of my macros are running, I have ScreenUpdating=false . I update the progress for the user by changing the Caption on a Command Button and then turn on Updating and then turn it off. It works just fine. I was wondering, however, if there was a way around turning...

Please can you help an excel novice with a question on how to write a formula using the IF function to detect certain text in a column of a spreadsheet and then to turn numbers in three other columns into negatives if that text is true? Thank you :)

Hi All, I'm trying to reference =Sheet2!B6 . My question is, if the cell is blank in Sheet2!B6 how do I make this formula turn up blank and not represent a 0 ? Many thanks, pinaceous

Hi experts I am trying to plot a nested x axis in a stacked or your standard column chart in Power BI and it's turning into a nightmare... I have Turn on responsive under "General" formatting and Turn off "Concatenate labels" under X-Axis.. cannot see the wood for the trees....sample data...

I am trying use conditional formatting to get cells in Colum b to look at the adjacent cell in column c and if c=delete then turn the font red. I used in b2 I placed =$c$2="delete" and set the font to red. Nothing happens. Any one know why?

I have the following data on a spreadsheet: Excel 2012ABCDEFGHIJKLMNO1Line TypeQte Line No.ProductTechnical InfoAdditional Items2Booster...

Hi, I'm wanting to make some dates within a spreadsheet change depending if the date is older than six months (turn red), is two weeks before the six month deadline (turn amber) or is within the six months (turn green). I can get the dates to turn red and green but it is the formula for the...

Hi Gurus, I've been trying and failing for too long at this so i'm here for some help. I'm making a training matrix that uses conditional formatting to alert me when training is about to and has expired. So for example, on 01/01/18 Mr. Smith took abrasive wheels training. The training will...

Hi everyone, I have the below macro which is a conditional format for certain cells, that is part of a larger macro. I am just wondering if there is a way to also insert a toggle button via active X I am thinking to be able to turn this function on and off?? If so, what code should I add to...

Good Afternoon All, I am trying to format a celll to turn green based on the last numbers in another cell. So G5 says Machined components = 150 and I want G18 to turn green if the total matches the number after the = in G5. I also want G18 to be orange if the 150 is not met. Can this be done...

Help please: I have 2 columns, A and B - I need a formula so that when I enter a value in Col A, the adjacent cell in Col B shows today's date plus 21 days.( "TODAY" function is no good as I need the date to be 'fixed' once it is calculated and displayed. This is in effect a mandatory...

Hi - grateful for any help. I have a table and need to identify errors Namely I want E2 to turn red if greater than C2...that fine but when I try to extend to look at each row in turn ie E3>c3, E4>c4 im getting some strange results.... THANKS IN ADVANCE......

Hey guys, coding a basic ai for a game, and the enemy always moves down and left, instead of what I tell it to do. Thanks! Sub moveStart() '2 right, 3 down, left to 10 If turn = 0 Then Range("monster.l1").Value = Range("monster.l1").Value + 1 turn = 1 MsgBox turn GoTo Ender...

I am trying to select a cell in one sub then call another sub and turn the “active cell” red, can anyone help please?

<tbody> Task Name A B C D A <tbody> 21-May-18 </tbody> <tbody> 31-Aug-18 </tbody> <tbody> 13-Jul-18 </tbody> <tbody> 17-Jul-18 </tbody> B <tbody> 23-May-18 </tbody> <tbody> 31-May-18 </tbody> <tbody> 7-Aug-18 </tbody> <tbody> 24-Aug-18 </tbody> C <tbody>...

Hi All, I have three values feeding into three cells on a separate tab (tab 2) Overall Total - 650,281.44 Value 1 - 311126.58 Value 2 - 339154.86 On tab 2, the overall total is recording as £650,281, it has been set to turn yellow if this value does not equate to value 1 and 2 being added so...

Hi guys, I am fairly new to excel so I don't know very much. I have done A LOT of googling and trying to figure things out - and so far I have succeeded pretty well. However, there are 2 things that I can't seem to find the answer to (and honestly I have a difficult time understanding some...