right

I have extracted some data from our employee database. It's 10,000+ rows. The first row of the employee is their name, a hypen, then their 9-digit SSN (11-digits including the two hyphens in the SSN). After each employee is 2-7 rows of deductions. The last row of the employee has the total...

Hi all, I have a lot of cells that look like this: Now, what I would like, is to have a formula that returns ONLY the top part of cell A3 I have separated the texts by pressing ALT + ENTER and then typing: Test 1 Test 2 Test 3 instead of Test 1 Test 2 Test 3 Is there a way in which I...

Hi all, I am currently trying out this formula: Copy of my formula: =if(A5=Left(A5;5)="Bob G"OR(A5=Left(A5;5)="George G");"This formula works!";"This formula does not work!") Essentially, what I want to achieve is for my formula to return "This formula works!" if the value in cell A5 is...

Hi all, I currently have a very large data sheet that looks like this: In this example, I've just put in a format of: Date,Name,Gender Please note that some of the cells however might only have Date,Gender or Name,Gender or Date,Gender etc. My ideal format would be: Date,Name,Gender...

Hi all, I am currently working with a data set that looks like this: I would like a formula that takes all the values in column A, and if they begin with a comma (","), it should remove this So the result should be like this: Does anybody have a formula for this? It would be greatly...

Hello hope this is easy answer that I’m missing I’m wanting to use a RIGHT function on a return value The return value comes from an Xlookup that needs to be active (can’t’ copy and paste values then use RIGHT) The value that XLOOKUP returns is 360abc I want the 360 gone automatically each...

Hello - Trying to come up with formula that will give me the number from a different cell, but the cell I am trying to reference also had letters, Example: The cell referenced, lets call it A1, contains: '4 yrs'. I would like cell A2 to calculate 4. I tried doing a =LEFT(A1,1), but the issue I...

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

I'm looking for some VBA to extract the text: 1620011017 from the below string; Inv_1620056384_1620011017_1034258 There could be any number of characters, so I think I would need to define it based on the fact it's the string between the 2 underscores. I think starting from the right of the...

I have a table which contains Transaction Total in column N, all columns to the right are different transaction types and their cells contain the monthly total. There is the possibility for additional columns for new transaction types to be added to the right of column N. Because of this, I am...

When I use the ISNUMBER or ISTEXT function for the whole cell, it gives me the correct true or false result. When I use the ISNUMBER OR ISTEXT with the right function to extract the last 3 characters it is giving me the incorrect results. I want Excel to see the the last 3 characters as if it is...

my issue is getting the default zip code of 99999 answers when the extracted is not a number. I tried isnumber, but it kept rejecting with too many arguments message

ISO VBA command to insert a dash (hyphen) as the 5th character from the left, and 6th character from the right, in a string of varying length, within an array. For example... Column Z contains the following list of values: MSEAVIMA0013S MSEAVIRM0016S MOLPVIRM0017S MOLS130012S MSEAVIRM0011S...

I have a string of text in Google Sheets - I would assume is the same formula I can get the first 2 words - but not sure how to expand to get 3rd + In Cell F2 I have typed: (no bold) Wall panels for interior wall FIRST WORD =LEFT(F2; SEARCH(" ";F2;1)-1) SECOND WORD =MID(F2; SEARCH(" ";F2) +...

Hey, I have a query regarding the text limit on a cell. I have a cell that contains more than 100 characters. I have given the reference of that cell to other sheets now what I want is that on the sheet the cell will only have 100 characters the rest will move to the next cell. Exp. A cell has...

I've got this nagging situation/s. In my excel files I've this: examples in the tables are as below: Names FirstName MiddleName LastName Roberto Engelesias Darwin Subramurthy s/o Thirumurthy Abdool Kassim ibnu Murshid Azmi Bin Abdullah How do I seperate it into...

I have a large VBA project I'm working on that uses the "Right" function a lot. All of a sudden it gives me an error message of... "Compile Error Wrong number of arguments or invalid property assignments." When I try to compile, with the "Right" Function highlighted. What's really strange is...