break

Hello I have a workbook with a link to and old file, i have tried to break the link, open source, change link, get rid of any conditional formatting, delete irrelevant work sheets, data validation etc, but i still cannot break this link! Does anyone know anything else i can try? Thanks

Hello, I have a text file with a lot of data. There are 2 columns. One column is names of company. The other column is summary of conversations (long text with a lot of line break). The delimiter is ; and the separator is ". The problem is that when I try to import the data, excel understand...

I am Daphne from the Netherlands and I have a urgentquestion. I have to make a sheet/formulas for work. I can work with Excel but don’t have the whole knowledge of it. Ok what is my issue. I hope I can explain it correctly in myDutchy/English. Sheets contains personnel names, days, start...

Hello Excel Gods! Please help!:pray::pray: In Cell b2 i need a formula that will find a2(john) in column J and sum the same type of event for a2 from column J that is for a2 matching the name in b1:H1 Some notes Column K is in the format Hours, Minutes, Seconds The cell to the right of the...

Hi, I have the below code, which adds buttons(shapes) to every cell from range A2:A200. I would like this to be more dynamic, thus the desired result will be for this to add buttons based on an adjacent column, let's say Column B. So if column B has data until line 40 i would like to have on...

Hi I am trying to do an IF then statement. I have a list of items that if a cell contains I want it to say Deduct or no deduct, no matter what I try the formula only returns No Deduct. The formula is listed below: =IF(OR(J876="EXTRA BUNDLING CHARG",J876="SPECIAL PACKAGING", J876="COMBO GASKET...

As the title reads, i'm looking to see if there is code to break external links only on specific tabs in a workbook. I have found a few codes on this forum, however, they all break external links in the entire workbook - not specific tabs. I can provide these code if necessary. Thank you!

I am working on a bibliography. (EndNote) I am converting it to excel. The Author cell looks like this: <tbody> Akil, Ali, Ziegeler, Stephan, Reichelt, Jan, Semik, Michael, Müller, Marcus Christian and Fischer, Stefan Several questions: How do I break up the authors and get rid of...

I need a formula to match words contained in a phrase (B) to values in a list (A1:A5) and copy the matched values into a cell (C) e.g: <tbody> List Phrase Matched words break hot tub forest break break, forest cabin log cabin cabin cottage cottage break cottage, break forest forest hot...

Dear All Need an urgent help to get the below scenario sorted. I have attached 2 sets of Data. In Sheet2, there is a TV Ad data aired on different channels. Explanation of each column below Channel: Name of the Channel Date: Current Date AD Start: TV AD start Time MidBreak: Tells about the...

Dear All Need an urgent help to get the below scenario sorted. I have attached 2 sets of Data. In Sheet2, there is a TV Ad data aired on different channels. Explanation of each column below Channel: Name of the Channel Date: Current Date AD Start: TV AD start Time MidBreak: Tells about the...

<tbody> <tbody> 601, Khatau Condominium J.M. Mehta Road Nepean Sea Road Mumbai 400006 </tbody> <tbody> 601, Khatau Condominium </tbody> <tbody> J.M. Mehta Road </tbody> <tbody> Nepean Sea Road </tbody> <tbody> Mumbai 400006 </tbody> <tbody> Gold...

Can someone please try this and see if you get the same problem? In a new workbook, put the number 1 into cell A1. Then add a Data Validation rule, stating it must be a whole number greater than 0. Now in the VB Editor, put this is Sheet1: Option Explicit Private Sub...

Hi all! In a worksheet where there are several pages active in Page Break View, is it possible to deactivate any of them even though there is information on them? Thank you! Russ

Hi All! Is it possible to set page breaks by the value of a cell? Example: Cell A50="Page Break". Page break is the inserted in row 50. Thank you! Russ

In cell a1 I have a concatenate formula with this result 1-2-10-12 I would like to break that out to col b ,col c, col d and col e showing them as separate individual numbers b1=1 c1=2 d1=10 and e1 =12 at times these numbers will change so I want to accommodate a two digit or one digit...

Hey Guys... How can I add a break line between when a new set of numbers appear... <tbody> Date Post Track Racenum 3/20/19 16:00 CT 1 3/20/19 16:00 CT 1 3/20/19 16:00 CT 1 3/20/19 16:00 CT 1 3/20/19 16:00 CT 1 3/20/19 16:00 CT 1 3/20/19 16:29 CT 2 3/20/19 16:29 CT 2...

I wrote VBA Code. Upon execution I hit CTRL BREAK. Now everytime I run the code it stops on the same line of code. Highlighted in yellow. What I've tried: I have hit stop in code. Have selected CONTINUE. Have deleted the line and re-entered it. How can I get this to run straight through again?

I need helping breaking a link. I have a file that is supposedly linked to another employees personal file on their computer and when I go into Edit Links and click break link and I get the pop up to break the link but then nothing seems to happen and the link still appears to be there. Any...

This is a simpler version of something that is much bigger, how do I break down data in excel from this format to this format? ID TagID 400 1:5 483 E21.3:E21.5 ID TagID 400 1 400 2 400 3 400 4 400 5 483 E21.3 483 E21.4 483 E21.5