len

hi, I'm using Scripting Dictionary to make unique list: Dim count_result As Long count_result = 0 Set dict = CreateObject("Scripting.Dictionary") For i = 3 To last_row looking_string = wsC.Range("O" + CStr(i)).Value If Not dict.exists(looking_string)...

I need to create a formula which will work out the length of a shift which is written in the following format: 9-5 or 10.30-6 or 5-CL (CL standing for close). I have all the steps in place but when I try and combine all the steps into one formula the #Name? error shows. <tbody> <tbody>...

I use Excel to calculate large amounts and totals because it works good. We work on a relatively primitive web based program that require manual calculation of large amounts of items at different rates etc. I use excel to do the calculations and then copy and paste it when completed into our...

I'm stumped, I have a cell value that is an address with leading numeric characters varying in length. I need to figure out how to either extract the leading numeric characters or insert a comma where the numeric characters end and the text string begins so I can do text to column and seperate...

Alright Excel friends, I had a problem that was solved that has just grown once more. I need to find and extract multiple strings from a text field. These strings consist of two letters followed by three numbers and possibly an extra letter. It could be XX000 or XX000X (e.g. AB123 or BA123Z)...

We have a master list of the name of all our clients and we receive new lists of attendees of a trade show that has the company names listed as they would list it, but that often doesn't match our master list. I want to be able to match a cell which has a word in it that is in another cell in a...

I thought this would be easy but it is not working. In Data Validation I choose Allow Custom and this formula: =AND(ISNUMBER(RC),IF(LEN(RC)>4,LEFT(RC,4),IF(LEN(RC) > 0, RIGHT("0000" & RC, 4),""))) Everything I enter fails. Examples of what I expect. Out In 0004 4 0023 23...

Dear All, I am trying to create a formula whereby a number is adjusted to a fixed amount of characters using leading zeros. Wait - it doesn't stop there.. The problem I am encountering is that these numbers are in an outline style - 1.1, 1.1.1, 1.1.1.1 and so on. I need a formula which...

Hi guys and ladies, I have yet another question that I hope somebody here knows the answer to. I have the following situation: A single Excel sheet with a total of 44 columns that contain content. The content is devided as follows: A2 has text => B2 has LEN function to count the characters...

Hello VBA world... well this question is for Excel Function world: I am trying to parse a string and return just the text within a string. The text strings are the same but the ending number variations differ. For example, I have two comparable variables "XXX12" and "XXX2" and I'm trying to...

I've a large task, which I'm splitting up into smaller pieces: I'm trying to get VBA to output the number of plus signs in a cell (a workaround to how many other cells it adds into this cell). Sub TEST() ' ' Makro4 Makro ' Dim MyString As String Dim StringLength As Integer MyString =...

I have file locations listed in many cells. Example: folder1\folder2\folder3\folder4\folder5 I need a formula that will give me everything before the last "\" So in this case I would only like to see folder1\folder2\folder3\folder4 Any help is greatly appreciated

Given: A1 = KNZY A2 = NZY Goal: Append a "K" to the beginning of any cell in Column A:A that contains only three letters. Test1: Formula in column B:B =if(len(A1)=3,"K",A1) Results: A1 = KNZY ; A2 = NZY Test2: Formula in column B:B changed to =if(len(A1)=4,"K",A1) Results: A1 =...

Hi all -i'm brand new to this board (though I think i'll be on here quite a bit! :)) I have a problem in excel that i just can't get my head around, i'll try to pose the question as simply as possible as trying to explain why i need this is a bit of a headache!!! Basically, i have a list of...

Hello, I could really use some help parsing this data. All of the data is in the same field, and I would like to have each address field (i.e. Address1, City, State, Zip Code) in separate fields. 100 Laketrail Drive , Alpharetta, Georgia, 30022 1001 St Charles Ave , Atlanta, Georgia, 30306...

I thought this would be easy, but is proving to be difficult at least for me. I am using the CONCATENATE function to string together names and employee ID's. Both fields are variable length and I would like the ID's to follow the names, but all lined up so easily readable. I thought I could...

Hi All, Been grappling with this for a while - thought I had it solved before christmas but on revisiting, does not produce the reusult i need. I have the following working code which looks at a range (containing strings of text and mumbers with 3 letters followed by a number eg AAA1, BBB5...

Does anyone know a good formula to use to resize a column based on the number of characters in a cell. For example: i = Len(test) g = i (some formula to adjust i) Columns("X:X").ColumnWidth = round(g,0)

Hi all - i'm wrestling with the following problem;- I have working code;- Dim cell As Range Dim x As Integer With ActiveSheet For x = 116 To 147 For Each cell In .Range("M44:M75") If Left(cell.Value, 3) = .Range("H" & x).Value Then cell.ClearContents...

I am trying to use the code below to count the number of characters in a box consisting of many merged cells. I have named the range "Summary". When I run the script Len continues to return 0 no matter what I put in the "Summary" area. What am I doing wrong here? Sub AutoResizeText() Dim...