right formula

Hi, So basically I have 4 main possibilities: PYMT769291 INV 769291 INV 769291_1 -> This could be _2 or _3 or _4... INV 769291BD And I need 1 formula that makes them all convert into this: PYMT769291 -> This one should never change 769291 -> This one gets rid of the...

Hi All, I currently have data sitting in the first column A in the following format representing line items from Period 1 to 12 4-4030 Fees and Charges-Unrestricted 5,623 5,811 5,610 5,733 7,563 5,417 5,484 6,152 10,962 4,487 4,835 4,412 72,091 73,660 (1,570) 4-5035 Recoupments 0 0 0 0 0 530 0...

Hello, I am currently trying to combine a sumif and a right formula however I am at the stage where I am unsure if I am able to. I have multiple descriptions in column A and each description ends with a specific word like as follows: <tbody> A B Tom - Red 1 Tom - Blue 5 Harry - Red 3...

https://www.amazon.com/Gerber-Sundress-Bloomer-Sailboats-Months/dp/B06X9R9KRG/ref=sr_1_1?s=apparel&ie=UTF8&qid=1499285599&sr=1-1&nodeID=7628012011&psd=1&keywords=baby+girl+clothes I want to have a formula to locate the "dp" in this link and than count 11 characters Results of the formula...

Hi all, I have a confusion with using RIGHT function. I need to create a complicated formula that depending on two digits after comma. I’ve used RIGHT function to do it but the step that you can see below, the result seems like isn’t true. I'm sharing formula with the sample values(not cellIDs...

Hi people, I am having trouble establishing the correct formula for inputting scores. 5 players in a team (each seeded from 1-5), each playing best of 5-games. Example of results... 0-3 (1) 3-2 (2) 3-0 (3) 3-2 (4) 3-1 (5) 0 0 0 Overall result in new cell needs to formulate to: 12-8 I have...

Needing to get these 7 digit numbers on their own, thinking it's a combination of the Left and Right formulas Number of characters is not constant so preferably wanting to trigger on the _ (underscores). Any help greatly appreciated <colgroup><col></colgroup><tbody>...

I am new to the forum and have a question regarding which type of formula to use... I have a set of values that export as text ($12.0K, $11.0K, $8.2K, etc.) and need to get the numerical portion out into its own cell. I know the right, left, and mid formulas can do this, however I am having...

Hi, I have what I think is quite a simple issue, but it's baffled me! I have a list of postcodes and I need to add a space in the middle in order to use it with another data source which are already formatted this way. I currently have postcodes such as 'PR88AG' and I need to add a space...

Hi! I'm new to this board and I'm sure this is a very simple solution however I'm stuck right now. I have a column that looks like the below however consistently changes in number of characters and letter. I need to be able to separate the numbers from the letters as they are the unit of...

I am trying to enter formulas I have used for years, but I continue to get the general error message: The formula you typed contains an error. For information about fixing common formula problems, click Help To get assistance in entering a function, clcik Function Wizard (Formulas tab, Function...

Hey all, I'm trying to look at the last character in a cell and determine what it is. If it's an asterisk (*), I want it counted. So I assume that's some blend of countif and right, but the hangup is the length of the characters in the cell can vary; some are ABC123, some are AB123456, etc...

I require a formula to give me the team name in one cell and the odds in another. Basically separate the letters and numbers. For the odds I require possibly an =right formula to give me everything on the right of the ‘space’ that is furthest right. I’m not sure how to explain getting the name...

I need a formula either =left, =right or =mid to give me the contents between the brackets as of below. So I need ‘15/8’ on the first row to be displayed, ‘4’ on the second, ‘17/11’ and ‘11/10’. <tbody> QPR (15/8) Aston Villa (4) Burnley (17/11) Newcastle (11/10) </tbody>

hi, I have simply formula in loop: Set WS = WB.Sheets("Sheet2") Dim b as String For j=1 to 6 b = ActiveCell.Formula = "=MID(Right(WS.Cells(j, 2),9),1,6)" next j and my result is always false. Do you know why?

I have a spread sheet with VIN for vehicles, another spot for just the last 4. Entire VIN in Z3, last 4 I want in C3, I placed formula =RIGHT(Z3,4) in C3, when I click on this in the text bar, it does highlight Z3, but the it only shows the formula, not the last 4 of the formula, I am using...

I have a cell with the value Western Washington University - 516 High St. - Bellingham, WA 98225 ( in bold ). in this text string i have a university name, street address, city, state abv. and zip. I need to extract each individual value in to its own cell, the format of the text string...

I have a spreadsheet of about 4000 rows. I have shipping box dimensions in 5 columns per box (L x W x H x Weight x Freight Class), with a total of 8 potential boxes. Columns AR - CE (40 columns) are split into the 8 groups. Box 1 :AR - AV Box 2: AW - BA Box 3: BB - BF ..... and so on. For some...

Is there a way with "Data Validation" where the data that shows on the drop down box, when selected, only displays the first five characters on the cell. For eg In a worksheet, List Range has got data validation settings whereby the value to be input in those cells comes from a list. The list...