len

Hello and sorry for the crappy subject header. As stated i need to change "Smith, John" to "John Smith" but the name could be "Experticus, Vba" to "Vba Experticus" - dynamic length of each. I assuming it has something to do with" LEN", but that is one area that i cannot get to make sense to me...

Good morning, I have this text, (and it changes but it'll always be annual. Feb-Jan, July-June, etc.) and I need to pull the starting date from the cell. For the Period: May 01, 2021 to January 30, 2022 I currently have this formula but it'll only work for some of the months, not all. For...

So i have a cell with product codes inside of that. for example cell a1 contains data - 1x ddjed8cx7ee cell a2 contains data - 4x ddjeudaadi3 cell a3 contains data - 1x nddnadjnfke 1x ajo37danunau 4x aud73ndnnak and so on I am trying to find a formula that can A. return the value of 30...

Hello, please help, how do you do it if you want to take a character into a number 2, 5 like in the result column? I've tried using if, len, and mid but it doesn't work. Thanks =IF(LEN(A2)=7;MID(A2;3;1);ISBLANK(" "))

Hi guys, I'm trying to insert a formula in my code which works in the sheet but not in vba. Running the code below returns a syntax error. I noticed that the errors are due to SEARCH strings containing paratheses for "ENO=" and ",SUB". I've tried changing the paratheses to CHR(34) as well but...

Hello Everyone, I'm looking for a formula that would cause a number value to either increase or decrease by one. Examples of text include: Apr Y0, May Y0, Jun Y1, Jul Y4. The common denominator is that the number is always preceded by " Y". Thanks in advance for all your expertise! Please let...

Hi there First post, hopefully I've followed the rules. I've had a good search but can't find anything specific to the issue I am having. It's very basic so I'm surprised it isn't working. I've attached an image that hopefully clearly explains the issue I am having. Basically I'd like to...

Hi Folks, I know this has been asked a thousand times and I'm trying to implement some of the solutions I've found but I just can't seem to get this to work. I have values in column I that four decimal places deep and I simply want to remove the last two characters. The problem I'm noticing...

Hi all, I am using a formula which uses LEN and SUBSTITUTE. The formula works (I didn't learn it by building up, I got it from a tutorial), and I understand what LEN and SUBSTITUTE do separately, however, I don't understand what they are doing in this formula. I was hoping anyone would explain...

Hey guys, Can someone assist me in writing a formula for counting how many "I" are in a range of cells. For example I have a range of cells B11:AF12 that have different letters in it to identify the kind of Lead Source we receive. "I" represents Internet. I need to find out how many I's are in...

Hi, Hope that someone can help me if this is possible to do in a formula. Sorry that I can't post screenshot of table because I couldn't get the add-in to work. :sad: Name Run Out Tim 6 1 John 5 3 Len 6 3 John 3 4 Len 4 2 Tim 2 3 How i would like to...

Hi, I am looking for a way to verify if a cell say A1 contains same digits like 1111, 2222, etc. The Len will always be 4. Thanks in advance

Hi I have set-up the below but the LEN calculation seems wrong as LEN that isn't 15 is matching and doing the workday function. Can anyone see what is wrong please?

Hello, This on has me baffled and I tried everything I could think of. Longstory short, I'm working with an old windows program that extracts data into anexcel worksheet. There are a ton of rows,but many are useless (like headers, totals, other stuff) Anyway, I did discover that the data I...

hello all, I need help with the funtion I am able to do len first and then if function but i cannot get them to work together. I need a function that can take the Length of the numbers in cell B17 and if greater than or equal to 8, display a value of "Cusip" If the length is less than or...

My Task is to Summarize the Ingredients By Categories. I have two Worksheets/Tables. The First lists the Categories and their respective Recipes CategoryRecipe <tbody> Category (A) Recipe (B) Cat1 RecA Cat1 RecB Cat2 RecD Cat2 RecC Cat3 RecA Cat3 RecD </tbody> Next is the...

I have a value in a5 (82700000) Needing it to display in a6 as text 82.7 Million. Could also be 827000000, needs to be displayed as text 8.27 Billion I know it has to do with Len Just cant get there, Any tips or solutions are greatly appreciated. Jack

I am trying to make a formula which basically says "find the first word that starts with G then choose the word AFTER it" but i cant configure the formula correctly, i am a bit of a novice! i can do it by combining IF statementslike this: =IF(TRIM(LEFT(SUBSTITUTE(MID(B4,FIND("G",B4),LEN(B4)),"...

Hi I am trying to pull from the sheet below into my cell the first and last name from Job Costing. In the sheet below first name is in C2 and last name is in B2. Then eventually I would scroll down. I looked up =Right Len, but confused its saying maybe I need to do =Left len any help thanks...

Hello wise people of the internet. I'm tinkering with a code in VBA. It's purpose is to look at each cell in a given range. Part 1: Looking at the LEFT side of a string, it searches for "/56-Test1/" And it MUST be the first part of a string. Example: "A/56-Test1/AAA" should be ignored while...