len

Hi, I have the following example URLs: https://viyet.com/andrianna-shamaris-teak-and-bone-inlay-circular-bookcase-sto-49740-27277.html https://viyet.com/janus-et-cie-large-shell-bowl-acc-49959-2600.html https://viyet.com/jonathan-adler-danner-loveseat-sea-45150-33425.html The length is...

Hi all, Below is my code: Sub RedistributeCommaDelimitedData() Dim xArr() As String Dim xAddress As String Dim Rg As Range Dim Rg1 As Range On Error Resume Next xAddress = Application.ActiveWindow.RangeSelection.Address Set Rg = Application.InputBox("please select...

My current formula is =SUMPRODUCT(--(A11>='Front End'!B$25:B$72),--('Front End'!C$25:C$72>=A11+"00:15"))+SUMPRODUCT(--(A11>='Combo EE'!B$36:B$69),--('Combo EE'!C$36:C$69>=A11+"00:15")) I'm having an issue because when I copy data in the range C25:C72 and B25:B72 the time now has a date in...

I am using Len Function to count number of characters: =LEN(A1) Now, I have instances that I would like to count as one character and not 2. For example, instances like "DZ" or "LJ", if they exist anywhere in the word it should be counted as -1 to the total of characters. I can solve this...

In part of an ongoing larger project that a team member is helping me with, this will help me get one step closer, I've tried using =RIGHT(B3),LEN - N but due to the nature of the "Titles" in column B3 being different # of characters to the right, I thought there but be a more direct and simpler...

Hi, I have a list of data in sheet1. Column A contains cells which all contain text. They are capital letters apart from the right hand value which is lower case letter ("a", "b", "c", "d" or "e") e.g "TELEVISION.a", "TELEVISION.b" and so on until "TELEVISION.e". The item varies and the length...

Good morning all. I'm a bit stuck as I cannot use a LEN command with the problem I have. I have had a look around the site and cannot see a simple (or even complex) fix. I have an extract from a BI system that in four columns produces a text field with a date in the format: January 1, 1900...

Hi All, I would like to make and IF function in VBA, i have tried with this one with no luck: If len activecelloffset(0,0) >=36 then .... Can somebody help me to make this if function work? Thank you so much in Advance

Hi all, My problem is I have a set of part numbers as below: 063G4F1000 0300 004EWL0450 0550 004D1 0350 0300 004D1D0350 0300 002 AB20242408 002 DGPS50 What I need to do is extract the first part of the number to achieve 063G4F 004EWL 004D1 004D1D 002 AB 002 DGPS I have around 11000 parts to...

Hi, I have a data in column A as ASR903/I-AP-VKPM-ENB-0178/VKPMGLNMPAR001/172.16.98.137/PSU fail 2/10 --> a1 ASR903//I-MH-PNJI-ENB-0070//PNJISNGLPAR002//172.16.98.38//p0 unknown --> a2 ASR-903// I-WB-ASSL-ENB-0077 *ASSLNCPRPAR001/172.16.58.119//P1 fail --> a3...

I have a lot of lines in a data set that look something like this: 006MSP95228184 006ATL95228195 006ORD95485250 I don't care about anything but the 95228184, so I used the following function to rid myself of it: =IF(LEFT(A1,3)="006",RIGHT(A1,8),"") RESULT: 95228184 - excellent right...

I have the following number and LEN() formula, As you can see that LEN(), counting 15 for all other and 16 for the last one, while they all 16 characters long. <form id="form" onkeypress="javascript:return WebForm_FireDefaultButton(event, 'cphMain_btnSearch')" onsubmit="javascript:return...

Hi all, I have a block of text in a cell, this block will contain 1 or more dates. They may be formatted as January 2017 or 01/01/2017. I would like to write a formula to replace the first style with JAN2017 and the second style 01JAN2017. I am trying to work out a way to do it combining...

for example: can a word in a cell "star" be extracted into another cell as "s.mp3,t.mp3,a.mp3,r.mp3"? the words can be a of varied length .. the final output can be concatenated .. but the issue is that the words can be of any length .. example - "ant" or "butterfly" or "enlightenment" .. i...

I'm learning as I go with Excel, and can't get my head around how to write this formula (if it is even possible). I want to count the characters in a cell, but exclude certain characters (plural). E.g. coding and spaces. I know how to count the characters and exclude only spaces...

I am using Excel 2013. I downloaded a Bank of America Export that shows many transactions that have originated from employees using their Debit Cards. Each Debit card ends in a different set of 4 digits. I am trying to create a formula to FIND these 4 digits (they are usually after a bunch of...

Hello, everyone. I have successfully done the separate parts of this operation but am getting repeated errors combining them. I need to have one workbook (Overview.xlsx) look for a specific name within a range on another (DesignData.xls) - when all instances of that name are found, it needs to...

Hey guys, hope you all are well. My sheet - I got - is a big mess. in the cells there is a full sentence with some numbers which I want to get, for instance: TEXT Fee: 123$ MORE TEXT Rate: 456$ MORE TEXT The sentences never have the same length and never the same text Main Problem: How...

I'm working with a huge data set of full names compressed into a single cell. I have another cell on the same line with the same name but the order of the parts may or may not differ. Parts are separated by spaces. So say Cell A1 is "John Q Doe" and cell C1 could be "John Q Doe", "Doe John...

Hello all, I am trying to extract characters 2 to 6 from the right of a field. The left characters are a user's name and vary quite a bit. The code I am trying to extract is 5 characters in between (). For example my list will be filled with records like this: John Smith (PQ123) or Susan L...