dash

I have cells that i am trying to add.... A1 - FEB 16 - 60 B1 - FEB 17 - 45 C1 - Feb 18 - 120 The cell has a date, then a dash and then a number -I would like to be able to add the numbers after the dash. So for the 3 listed above it would sum 60+45+120 = 225... Thanks

Hi!, My variable has the string in the following format key = ABCD8E-FG6HI-7JKLMN (alpha numeric) separated with dash Note that the length of the key is not fixed. Required output partA = ABCD8E PartB = FG6HI PartC =7JKLMN Thank you!

Good evening Looking to insert a dash if cell value is a zero using With range("E2:E" & lastrow) .numberformat = ????? .Value = .Value End With

<tbody> wind.size 3 0 - 8 4 3 - 2 1 27 4 5 3 2 10 </tbody> 1) I want to create a moving average (going to the right) with a defined window size (A2). 2) I don't want to return a number if the character above is a dash. 3) For the moving average I want to skip cells that...

Hello, <tbody> Item Qty Output P18456 2 P 18456 quantity 2 SP10458 1 SP 10458 quantity 1 SR10456-9 2 SR 10456 dash 9 quantity 2 E8986 4 E 8986 quantity 4 </tbody> Please refer to the above table, we have the following formula to translate col A and Col B to the desired output...

Hell All, I need a macro, preferably, but a formula might work to check the contents of the cells in Column C of my report, which is usually about a thousand rows long. The format should be like this example: 08-12-2017 DCV It needs a two digit month, a dash, a two digit day of the month, a...

I want sheet 2 cell b3 to update based on what is elect in sheet 1, this contains list of stores . and sheet2 is a dash board which is already built. So if i click ona value in sheet 1, sheet 2 should show up with dash board based on selection in sheet1 . can someone suggest a suitable vba code

Hello, any thoughts on why the below macro is resulting in a runtime error 13? I am trying to concatenate the values in column N and DO with a "-" in the middle. If I remove the "-" it works..... just not sure why I cant put a "-" between the two values. I also tried without "" and it doesn't...

Hi I'm trying to obtain this format TT-T#-T# and I'm using this formula but when I tested it failed to follow the pattern in text and numbers, it only kept the 2 dash 2 dash 2 format...

Hello, I need to keep my numbers in thousands (ie. 456,798 as 456.798 or 7,000 as 7). In addition I need to have all cells that equal zero be displayed as dashes "-". How do I format my cells? Thanks!

I am trying to format a report field to accounting (called the accounting format in Excel, not sure about Access). In particular, I'd like the zero values to show as dashes (hyphens) rather than 0. My report is based on a query. I have searched the board and google results and cannot find...