rid

Help, I have many, many cells that have a date and time in them like this 02.08.2018 - 10am I want to remove the - 10am section How do I do this please?

#VALUE ! AND 0 How do I get rid of these when I use this code =MID(LEFT(ues!C2,LEN(ues!C2)-11),FIND(" ",ues!C2)+1,255)&", "&LEFT(ues!C2,FIND(" ",ues!C2)) and this one too =MID(LEFT(ues!C2,LEN(ues!C2)-11),FIND(" ",ues!C2)+1,255)&", "&LEFT(ues!C2,FIND(" ",ues!C2))&"ICE"

<tbody> Table 1 RID Amount Count Elephant 500 2 Lion 600 4 Zebra 800 6 </tbody> <tbody> Table 2 RID Amount Count Deer 500 2 Lion 800 5 Zebra 700 5 </tbody> Desired Result <tbody> RID Amount Count Elephant -500 -2 Deer +500 +2 Lion +200 +1 Zebra...

Hey all! I'm new here. I'm having some trouble with my formula. Im trying to get rid of everything after the last hyphen in the respective cells. here is what i have so far. =IF(LEN([@[column1]])<=10|[@[column2]]|IF(RIGHT([@[column1]]|1)="-"|LEFT([@[column1]]|LEN(SUBSTITUTE([@[Andrew''s...

I am trying to do a vlookup however the text in A1 has a space at the end of it whereas the vlookup text does not. Is there a formula to get rid of the space at the end of the text in A1 that I could write into B1? Thanks!!

I am using this formula =IF(E2<>"",INDEX(TRAVEL!$B:$H,MATCH(E2,TRAVEL!$F:$F,0),4),"") but the city is not found so I am getting a #N/A how do I get rid of it?

Hi - I'm using the formula below to populate a list. I wondering can I use "LastRow" methodology for column BB in this formula? Can i get rid of the "0" at the end of the list in column AX, or is there a formula I can put in the validation that wouldn't include the "0" in the list...

I have a Worksheet with 7,000 rows, some of which have shading. In one of the columns, I started the last 4-digits of a credit card number with a hyphen. Over time, I have come to see that if you start the numbers with a hyphen, it requires you to have the hidden, leading apostrophe, which is...

in columnA I have a name and in columnB I have a value there would be multiple entries for the same name but different values in columnB i need to get rid of the duplicate entry but the values in columnB to be added together thinkng im gonna need to run a loop in vba

<tbody> "OSV TO BULK ANODIZE RED" </tbody><colgroup><col></colgroup> What fx can I use to get rid of the "OSV TO " and only show the rest.

Hey y'all I was just wondering if it was possible for excel to run a macro or condition that gets rid of deadlines that have passed and move the next deadline(s) up the table?

Hello I am using office 2016, and I want to know is there a way to disable the annoying pop up when you open a file that has links I want to get rid of this: https://imgur.com/a/ilt9U And have only this: https://imgur.com/a/axifr Any ideas ? Thanks

Hello, I'm using the formula =MATCH($L$1,$E2:$J2,0) How do I get rid on the N/A. I've tried just about everything I can think of. I'm using 2010 Excel. Thanks for the help!

My formula is =IF(E$110=2015,Formulas!$B4, IF(E$110=2016,Formulas!$C4, IF(E$110=2017,Formulas!$E4, IF(E$110=2018,Formulas!$E4, IF(E$110=2019,Formulas!$F4, IF(E$110=2020,Formulas!$G4, IF(E$110=2021,Formulas!$H4, IF(E$110=2022,Formulas!$I4, IF(E$110=2023,Formulas!$J4, IF(E$110=#N/A,""))))))))))...

I would like to know how to get rid rid of th parenthesis when it is copied to word...

Hi, I have been trying to get rid of the table names that seem to be existing, in excel's memory but i cannot locate or find them in that file. How can i get rid of all these previously named taebls and be able to reuse those names again? your help is greatly appreciated! thanks in advance. Krishna

When I paste something int my workbook, Excel 2020 brings up a little white square with (Ctrl) and a drop down offering "use Text Import Wizard". How can i tell it NOT to do that please? Also the only way I can find to get rid of it is to remove what you pasted. Words fail me!

Hi there, I have a spreadsheet that takes forever to save as it cycles through data tables. Bottom says: SAVING - DATA TABLE: 1 (goes all the way to 6 eventually) I didn't create any data tables nor is it in the name manager so I don't know how to get rid of them. Thanks, Jenny

In column A I have a long list of times but they all have the letters PM at the end. Is their a formula I could write in column B that would get rid of all the PM? eg in column A: 7:45PM 10:30PM I just want (in column B): 7:30 10:30 Thanks in advance

Hi Guys, I am current working on a Pivot Table where I have (Blank) in certain columns. Is there a way how to get rid of them??? Thanks in advance for your help.