dash

I have a sheet which keeps records of football (soccer) matches all over Europe. The scores come in like this 1-0, 2-1 and so on, but I'd like to be able to have the results column automatically update based on the native score, without using a helper column. Is there a way to do something like...

i am in the need for a regex for my vba project. i need to replace the - dash that is in-between numbers only, example 1-3-1. The problem is i have negative numbers with dashes which i need to keep, but the patterm is consistent, 1-3-1, should be 1,3,1 so replace dash between digits with a...

Hello all! This is my first post but I've been following this forum a solid 2-4 months in my journeys learning Excel and building dashboards. The resources present on this website have been of immense assistance. I've ran into quite a roadblock on my current project and was wondering if you...

Hello, I have a very long list of part numbers that I would like to summarize without the dash numbers. I would like to add "-()" to the end of the first part of the numbers like: 1D937K-1524879 becomes 1D937K-() 52D77-4 becomes 52D77-() 528-58-9999 becomes 528-() Is there a way to do this...

Hello- I am running a macro and have a column with numbers that areformatted as such: 15-3282 401-3264 6-3282 The dash can be in different places, How can I run a line of code that will reformat the entirecolumn? Thank you,

Hello, I again come with a quick-fix problem (I think). I have a field (VisitorID) filled by users via a form. I want to ensure that the format is followed so data can later be searched. The format is AB-1234. That is, 2 letters, a dash, and 4 numbers. I want to make sure the first 2 are...

Happy New Year to All !!! I have Column A, which contains ID numbers, as such...12-3456. Column B contains names that are associated with the numbers. When I combine the two columns into Column C, I lose the the "dash" between the ID numbers. I wind up with "123456" plus the name. I need...

Sorry this seems simple but not working for me. I want to compare to see if c4 > n4. If c4 > n4 subtract n4 from c4 else put a zero in the cell This isn't working for me. c4 currently equal to 35,844 n4 currently equal to 24,852 P4 should be 10992 but it puts a dash in the cell. Here is what I...

I have a macro that formats a set of data. Part of it is that I this line: ActiveCell.FormulaR1C1 = "=MID(B4,FIND(" - ",B4)+1,LEN(B4))" The problem is, I don't want a space before and after the hyphen. When I take it out and save, it puts the spaces back in and it's driving me insane. How can...

Hi Can some one please help me on the following. I have the following data , I only require the first letter after the 2nd dash if the letter is L or R or S and if the length of the characters after the second dash is 4 <colgroup><col><col></colgroup><tbody> Data Require BW1550T-NAV-L084 L...

I have a dynamic data input that at times has empty cells. Could be just one or more cells. I simply want to auto sum or add up each row of numbers up and down. However, it wont add because when there is no data it is represented as (-) dash. How do I get around this so it will ignore these...

I have a excel work sheet that I exported. in column "D" i have cost codes. for example 00-105, 00-600. some of them do not have a dash. for example 01600, 05300. What would be the fasted was in adding a "-" when missing?

Hi Excel Gurus, Can I please have your assistance. I have a column of numbers 'A' that I need to copy to Column 'B' but they need to come across in a different format as follows: Column A 000200501410 Column B 2-501410 Column A 001000499489 Column B...

Hi, How can I paste numbers with dash in between like the ones below and it calculates the total 37? In other words I want a formula that it removes the dash and calculate all the numbers together 2+2+4+2+2 etc.... 2-2 4-2 2-0 1-2 1-1...

Hello All, When I have a blank cell with no data, I want a dash to display...I am having trouble with the formula... The cell is G44, so I thought the formula would look like this: =IF(G44=0, "-") But a zero is displaying not a dash.... What am I missing? overlooking? Manny

I am trying to trim a lot of data from the form "10am-6pm" and "11.30am-9.30pm" to "6pm" and "9.30pm". I basically just need the finish time (I already have a macro sorted to trim for the start times). However I cannot work out why my current code isn't working. So far I have: Sub...

Hello, I have been really struggling with this, I need a formula that can extract the data before the 2nd to last dash. I have thousands of lines of data, and the data are all different lengths, with different dashes. Here is an example of data and what I need to extract <tbody> Data...

I have this <colgroup><col></colgroup><tbody> 1174958190-B33TB-DAA 1174988827-B33TB-RTR 1175002840-B33TB- AC042130-AECNA-AP 1175054679-B33TB- I only want the data BEFORE the second dash <colgroup><col></colgroup><tbody> 1174958190-B33TB 1174988827-B33TB 1175002840-B33TB...

In my Userform I have this code that when you put the customer number in and it populates the textBoxes with the customer info. I have a few customers that have a dash at the end such as 45610-2. It will not let me add a hyphen (dash). Is there a way I can use the dash on the userfom? Thank you...

sorry for creating another thread but in previous thread i forgot to mention this (i also tried but i failed) i have these strings: blah-blah-blahCK-N-blah blah-blah-blahLX-N-blah blah-blah-blahXF-V-blah and i have these "conditions" (2 different's) in "vlookup conditions" sheet: please...