digits

Hello, I need VBA which can transpose each 4th row, 3 by 3 columns, 1st digits before "-" in the columns N:P and last digits after "-" in the columns S:U. Example.... Cells C8, D8, E8 1st digits before "-" transpose in cells N8, N9, N10 Cells F8, G8, H8 1st digits before "-" transpose in...

Hello, i need do extract digits from One cell into 5 separate. <colgroup><col style="mso-width-source:userset;mso-width-alt:2706;width:56pt" width="74"> <col style="width:48pt" width="64" span="4"> <col style="mso-width-source:userset;mso-width-alt:4352;width:89pt" width="119">...

Hello, I'm using substitute nested many times to turn formulas with cell references into equations with text. It's a multipart process starting with a formula-to-text function generating a secondary array, some other stuff, and then a huge string of nested substitute functions generating a...

Hello, I’m looking for the total number of possibilities for a four digit entry where: 1. Available digits = 0,1,2,3,4,5,6,7,8,9. 2. Any single digit can only be used once. 3. Any combination of four digits are equal and only counted as one possibility (i.e., 0123, 3210, 1230, 2130 etc...

access 2010 I need to parse the data for the 7digit numbers within a string. The digits will always be 7 in length. Some data in () are not numbers. Some do not have ending ). example data: Park smith (sam) Park miller 23 WT 456 Bisa Keepan (2345678) Ington (3456789) Untom (3245678 I...

I'm trying to get the last 4 digits from a text box, to populate a worksheet. The issue is, when there are preceding zeroes in the 4 digits, they're not coming over. Example, if the text box has 1230456, I'm only getting 456 to come over. I need to get the 0456 to come over. I tried these...

MS Excel 2007. I have an address data base in which Column J contains Zipcode in 6 digits. I have this Column J formatted under category "Text". For convenience I have entered only last 3 digits, for example 096 in J2. My requirement: A formula for Column J. J2 displays 096. I want this to...

Hi All I'm after a bit of advice please. I expect someone has done this before. I have a list of 1000's of unique numbers between 1 and 6 digits that I want to increase all of to 8 digits. The problem is that I cant keep the existing numbers in the same order as they would be easy to guess...

I want to generate unique Id in column B, based on data in column C, D , E , F. I want first letter of Column C, first 2 letters of column F then all the digits of coumn E (digits only without . dot). can anyone please help? <tbody> A B C D E F sl no unique id name contact dob father name...

I have a string ... 12 : 07-Jun-18 - 20-Jun-18 I am looking for a vba solution to extract the whole number that starts the string. In this case, 12. If this number was always two digits, using left(string,2) would be a simple solution, but would not work for single digit numbers (1-9). The...

I have an issue with fitting a number within cell. i have 3 digit number, and it is within a cell with width bigger than for 7 digits. I want to spread these 7 digits so that, there are even spacing withing these digits, in other words fit digits to the cell. i do not want to split or put...

hi all... how to make fill series like this : <tbody> LPK-00008/1/1/WKN.03/KNL.03/01.00/2018 LPK-00009/1/1/WKN.03/KNL.03/01.00/2018 LPK-00010/1/1/WKN.03/KNL.03/01.00/2018 etc... LPK-00125/1/1/WKN.03/KNL.03/01.00/2018 </tbody> my goal in red font..always keep 5 digits number.. any...

I'm trying to switch surename and first name in column B, and put new name into column C. This bit of vba is working ok. But I only want this to be done if there are 11 digits in column A in the same row. Column A holds numbers, 11 digits for persons and 9 digits for companys. Column B holds...

Hi Guys, wondering if anyone knows how to rearrange data in a cell from smallest to largest. the length of the cell can be 1 to 20 digits long. Example: 1. 1,8,5,7,2 rearrange to 1,2,5,7,8 2. 9,3,7,2,6,1 rearrange to 1,2,3,6,7,9

I have a column of fields that I need to reverse the order by every 2 digits. Current: 021598 Need: 981502 So last 2 digits, next 2, then first 2 Also if the current number only has 5 digits, it needs to do the following, Current: 21598 Need: 98152 So last 2 digits, next 2, then...

Hi, I have five textboxes placed vertically. I have managed to make the cursor start in the first textbox. I will be entering one or two digits into each textbox. Is there any way that after I enter the digits, that I can hit the enter key to make the cursor jump down into the next textbox so...

Hello, I'm using substitute nested many times to turn formulas with cell references into equations with text. It's a multipart process starting with a formula-to-text function generating a secondary array, some other stuff, and then a huge string of nested substitute functions generating a...

I am trying to find a formula to count numbers in a single cell. I am able to achieve this but it counts numbers greater than 10 as 1 and 0. So if you had a list 1,2,3,4,5,6,7,8,9,10,11 it counts the number of digits, which totals 13 digits not 11 individual numbers. Can you assist?

Hello, I am trying to validate entries into a userform field to check that it only contains numbers and is 7 digits long. All i need it to do is highlight the field in red if the entry is not correct but not if the field is exited without entering anything. This is what I have so far: Private...

I have the following string in cell A1: Color=red;Length=5;Description=fast,Depth=10;Width=3 The numerical values in the above-mentioned string can be any number of digits (but, practically speaking, limited to 7 digits). For example, the string could just as easily be...