len

Hi people :) I need a little help breaking down this formula into business language - I get the gist of it, but I need to be able to explain the "rules" used to create the values in this cell (formula exists in cell U1)...

Hey guys, I need your help. The situation: I have 10 standard six-sided dice and want to roll values of 4, 5 or 6. This for example represents a game with 10 Goblins attacking a Troll, needing a 4 or higher to damage it. However, the Goblins are quick to strike so they can reroll their failed...

I'm having a blank moment. Once a string variable has been set, I basically need to check it for certain substrings within it, and get rid of them, and join the string back up. It will mainly be getting rid of any occurrences where there is a double, concurrent occurrence of "%2B" in the...

Hello Mr.Excel, I need a way to return the longest string within a cell. (number of characters) However, it should count strings based on line breaks within the cell. For example, == This is an example of text within one cell. == The above should return the value "24" Thanks!! Mike

I'm trying to match names of companies in one worksheet with another but LEN returns different values. I use trim and still different lengths. What can I use so they match? My goal is to use vlookup or another function to see company rankings on other worksheets. Can anyone provide advisement?

=IF(J22="","",IF(G9="","",IF(D10="","",IF(AND(J22<>G9,G9=D10),"Closing Disclosure Interest Rate does not match Note or ELC Interest Rate",IF(AND(D10<>J22,J22=G9),"ELC interest Rate does not match Closing Disclosure or Note Interest Rate",IF(AND(D10=J22,G9<>D10),"Note Interest Rate does not match...

Hi everyone, I have data in "A" column as follow : 00230536UE037; 86473UE023; 004729831HO0471. What i want to do is only to extract the Text from each one of the cells. Simple +Left/+Right will not work due to the variation of the number of characteres within each cell, and positioning of said...

Hi, I am trying to find a sub-string between two spaces in a string. Example String; 2PB IND3A 1MLGSTWIEL ANO I would like to extract 1MLGSTWIEL So far I have this formula... =IF(ISERR(FIND("ML",A1)),"",RIGHT(LEFT(A1,FIND("ML",A1)+1),LEN(LEFT(A1,FIND("ML",A1)+1))-FIND("~"...

Hi all, I have been pulling my hair out for the last few hours reworking this nested IF function. I have different values in A and b/c the numbers in front can change from two to three digits I have to use a LEFT/LEN function to remove characters from the right. My embedded IF function first...

Hello, I'm trying to use VLOOKUP to return only the first two characters in the look up cell. How do I adjust a vlookup formula to accomplish that? Standard VLookup =VLOOKUP(CELL1,Sheet1:A:B,2,False)

I want to add a column take the digits greater then the ones column over to the next column and add. example <tbody> Column A Column B 4 9 3 6 8 5 </tbody> 9+6+5=21 carry the 2 to column B and then add. The formula works on two digit numbers, however if column B is a 3 digit number or...

Good Afternoon, I am stuck on this formula. I am assuming its my formula that isn't reading the values but rather the result? A2 = 7891234567 =IF(AND(LEN(A2)=10,LEFT(A2,1)=7),"True","False") Any suggestions? Thanks for looking!

Hello people I got this string "2015-07-22" but I just want to have "07" Could someone help me with a code? Thank you in advance

I'm looking for a formula that takes the string in A1 and if the text is 4 or greater characters I want it to display the first 3...if the text is 3 letters long I want it to display the first 2...if the text is 2 letters long I want it to display only the first character....let me know what...

I have some VBA code in Access which inserts data from a form in Access into a Word Document. Code: .ActiveDocument.Bookmarks("XXXX").Select .Selection.Text = (CStr(Forms!frm_Main!ACCOUNT_NUMBER)) The account number in Access is 16 digits long. I have it working to where it will...

So here is my problem. I need to restrict entry in Cell B8 if Cell B3 AND/OR Cell B5 contain entries. Here is what I've done by way of a formula. I'm using Excel 2013 =IF(OR(B3<>"",B5<>""),LEN(B8)=0,LEN(B8)<=25) Basically, if Cell B3 or Cell B5 are anything other than blank, Make the length...

Hello there, I find myself at this, my first Excel forum, for I find myself with nowhere else to turn. Any help offered will incredibly gratefully received. I'm working on a holiday tracker, and it's pretty evolved as it stands. The issue I have two sets of staff on the same page but treated...

Hi folks. I need to be able to tell if any cell in a column is 14 characters long. I think the way to do it is a combination of either an IF or a COUNTIF statement and a LEN, but I havn't been able to get the Syntax right. I would prefer not to add another column that looks at the length of...

Hi I am trying to right a code that can read a set of strings that contains numbers and letters and I want to output only the numbers here is what i have Function ExtractNumber(rCell As Range) Dim iCount As Integer Dim i As Integer Dim sText As String Dim lNum As Long For iCount = Len(sText)...

Hi guys, I'm having trouble figuring out how to complete this data cleanup: I have a list of items that all follow the same format: 123456789012 Abc company 5 10-04-2013 bcdefgh company y p The items were copied and pasted from a PDF file, hence the messiness, and the misalignment of the...