digit

Hello smart people! :) I'm using a formula currently to extract the date out of a text comment, and it's been working well until we hit the double digit months. It enters the single digit months perfectly, as (for example) 09/13/2018. But in the double digit months, it's giving me (for example...

<tbody> A B C D E F 25 10 0 250 60 125 7 500 100 336 33 600 369.25 1425 526 181 </tbody> I want A x B = answer in two raw ( last 3 digit n "F" and first any amount digit in "E") what can i do ? pls help me

I hope that this is not too dopey a question. I have a column containing a variation of UK postcodes where there can be 1 or 2 letters and 2 numbers grouped together like DE74 or E7 followed by a space and a further digit like DE74 2 and E7 9 but I am having trouble searching specifically for E7...

I'm not sure if the best solution to my problem would be VBA or the application of several formulas but that's where the expertise of you all come in! I need to retrieve a six digit number from a single cell that is formatted irregularly. The number can appear at the beginning of the cell, at...

separate the trios with 6 different digits example = 06 13 25 = we have 6 different digits. yes can not have digit repeat ex = 01 12 24 we have the digit 2 repeated no can not only to separate in a list next to trio formations without repetition of digitios...

I'm looking for a formula that will double the same digit. In cell L6 I have digit 4 and need in cell S6 = 44. 1 = 11 2 = 22 3 = 33 etc... Thank you. Serge.

Hi Everyone, I have to sort some data and the text is all combined into one cell, I'd like to pull out the stock code number. now this is the second 4 digit number in the cell the data is in column A here's a few examples but the 4 digit can be anywhere in the cell but I'll use a few to give...

Hi, I have 39 numbers that are divided into 6 groups of 7 numbers, ( Group 6 only have 4 numbers ). Group 1 = 1,2,3,4,5,6,7. Group 2 = 8,9,10,11,12,13,14. Group 3 = 15,16,17,18,19,20,21. Group 4 = 22,23,24,25,26,27,28. Group 5 = 29,30,31,32,33,34,35 Group 6 = 36,37,38,39. I'm not...

Having in A11 digit 1909 and entering in B11 formula "=SUM(VALUE(MID(A11,ROW($I$1:OFFSET($I$1,LEN(A11)-1,0)),1)))" with enter and shift, display in B11 digit 19 then entering in,C11 formula "=SUM(VALUE(MID(B11,ROW($I$1:OFFSET($I$1,LEN(B11)-1,0)),1)))" with enter and shift, display in C11...

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, Now i got struck and need your valuable help here. I need to find the next number of a series of numerical values listed below, 505018 344936 677723 131820 198043 225002 776386 333117 544280 688659 760158 808183 487860 143137 345895 208028 224946 564152 764905 ------ ------ ------ how do...

Hi, i am trying to increment the last digit of a custom field. An example is 2018-08-001. The code i am using is left(a1,10) & 1 + right(a1,1) I am having issues when it reaches 2018-08-009. It becomes 0010. Also probable future problem is whenb it reaches 2018-08-999. Any help is appreciated...

Hi Id like to format a cell so that it formats it so that a "/" is shown between the 4th and 5th digits.. User enters 234501 Cell is formatted as 2345/01 Thank you in advance Al

I have mainly 6 digit numbers in Col B on sheet2 I need code that will delete all rows from row 2 onwards where there is not a 6 digit number in Col B See sample data below. I want all the rows to be deleted from row 2 where there is no 6 digit number...

I am currently writing macro and came across an issue. I would like my macro to delete every row that has a 6 digit number in column G. For example, if cell G44 has the value "220799" the whole row would be deleted, and so on for any 6 digit value. Any help would be appreciated. Thank you!

Trying to understand a round function. Formula reads like this =round(E3+E7-E42,5) My question is what is the last digit, #5 , doing to the formula? Is it rounding to 5 decibels?

Hi, I am new to VBA and trying to get to grips with it. I have a large list of phone numbers that are in different formats i.e. 01234 456 789, or 01234 456789 ect. I have managed to clear all spaces out to leave continuous numbers, now I want to insert a space after 5th digit of the area code...

Hi All - Here's the issue: we have 5 large spreadsheets that link to one master spreadsheets also large. All 6 sheets and the folder they reside in are named with the 2 digit year. We prepare the set of 6 sheets each year with what seems to be a zillion links each pointing to a file that has...

Example: I would like to select cells that contains a 5 only However cells with, for instance, 15 or 450 or 325 or game 115 should not be selected same goes for: I would like to select cells that contains -5- only Cells with 15, 450 etc. like above should not be selected. Any...

Good evening I have a pretty large data set. with certifications. I need to parse the numbers out (the 3 digit ones) <table class="tableizer-table"> <thead><tr class="tableizer-firstrow"><th>Certification</th></tr></thead><tbody> <tr><td>Intermediate Administrator (092)</td></tr>...