len formula

Hello everyone, I am currently working with a sheet that extracts data from a pdf that i upload using queries & connections. the string looks like this in cell B2 B2=IF(LEN(INDIRECT("Page002!C12"))=11,INDIRECT("Page002!C12"), IF(LEN(INDIRECT("Page002!D12"))=11,INDIRECT("Page002!D12")...

Hi, I'm trying to extract sale order numbers in a certain format but they have recently jumped up in character length so current formula doesn't work for all cells. Current formula is =MID(P2,4,7) This worked fine where number was 0001234567/00100. Now we have numbers such as 0123456789/00100...

I am working on contacts sheet which I need to get the name from email. Multiple cases I have to faced and with the help of below post link, I formed the sheet below. Extract name and company from email address Case 1: The mail id may contain separators like dot, dash and under-score Case 2...

Hi, Anyone can help me with the right formula to extract the last text from the right. In below example, I need to extract whatever text comes after ABCD 1 or ABCD2. AB1TEXTExpected Result2012 - USA - ABCD 2 GreenGreen3011 - USA - ABCD 1 RedRed4013 - USA - ABCD 2 YellowYellow5014 - USA - ABCD...

Hi, I'm trying to sort unique entries in a list of data. Currently I know how to find what I want, which can be done by the following formula: (INT(MID(F8,SEARCH(", ",A2)+2,LEN(A2)-SEARCH(", ",A2)-4) However I want to configure it to find the value in column A and paste it in column C, but...

Good morning all, I have the following formula on one of my spreadsheets, written by an excel wizard. I am trying to figure out what exactly this is doing. I know what the functions do individually, but not like thiis. Any help will be much appreciated, and thank you in advance to taking the...

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...

Hi I'd like to use the len and search functions in ONE formula. Scenario: I have a spreadsheet where users can input up to 4 characters in a column and they mean a specific thing eg "Jane Fonda" But then they'd only mean that if they contained EITHER a single number or a combination of...

Here is the formula I'm trying to use: =IF((LEN(S4:S6)=0,""),(LEN(S4:S6)>0,AVERAGE(S4:S6))) Unfortunately, I am getting error message " There is a problem with this formula". Do you see anything that I need to change? Your advise will be greatly appreciated

I have the following data: 15ab 12cc 6ll 9bc and i need to extract the number portion of the string. My text string will be either 3 or 4 characters long. If len=4, then left,2. If len=3, then left,1. I can't make the formula work in excel. Can someone please help?

I am trying to create a function that will recognize data beginning with "006" If it finds data beginning with "006" then remove all but the last 8 characters I don't know why I am having such a hard time with this one. Something like: =IF(LEFT(A1,3)="006"(RIGHT,A1,LEN(A1)-8) Thank you in...

Hello! So I've created the following formula that should create a new folder based on the year, but if it already exists, I don't want to create the new folder. This formula seemed to work well, until I did a troubleshoot of "2018" by replacing TodayYear with "2018"... it did not work then. Can...

Hi! I am trying to make a formula where the longest word in a range from a different worksheet, is reflected in the same cell where I create the formula. For example, Cell A4 should have the formula and the Range would be located in a Worksheet labeled Descriptions Cell A4 would show the...

Hi, I have a HUGE table of data and one column is all kinds of names that need to be parsed. I found two common types of arrangement. Last Name Mid initial first name (IE: Doe P Jane), the reverse order of that (Jane P Doe), and some variant that puts the mid initial at the end (Doe Jane P...

Hello all, I'm looking for a formula to remove a " from the very beginning and very end of a cell value. Any way to effectively do this? My current cell value is =Initial!C13 I need to do that but have the " removed from the cell value. Thanks, Andrew

Hi All I have (what is probably) quite an unusual problem where I frequently need to measure the amount of single and double byte characters in an Excel cell. The reason for this is that Google allows a fixed number of characters for PPC such as ads but for double byte languages, it counts any...

Excel 2007 <tbody> Row\Col A B C D E F G H 1 Inventory Value Report 2 3 4 5 6 Formula: Item Description Category UOM Qty Unit Cost Extended Value 7 KIT, OVERHAUL, 22 ITEMS PER KIT, OVERHAUL KIT 10000 HOUR ( COMPRESSOR ) SPARE...

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...

Hi, I am currently trying to import data from a website so that whenever I open up my spreadsheet it automatically updates my data to cut down on some of the time I spend importing each day. I have an imported web query but the data does not populate into tables like it is in the website it...

Hi, in column A I have email address: pawel.tom@gmail.com aqwe_12@yzf.pl audi_adm_2@audi.com In column B I want to get only: gmail yzf audi How can I do it?