break

  1. D

    Import from a text file to excel / problem with line break

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

    Calculate time with different shifts

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

    summing time spent per individual for a specific event

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

    Excel VBA - Creating shapes based on an adjacent Column

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

    IF then statement

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

    How to question: Break External Links ONLY on specific tabs

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

    Break up a cell....

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

    Formula to lookup values from a list and return matched value

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

    Urgent Help !!

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

    Help Required

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

    Transposing - Line Break Cell

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

    Worksheet_Change Event behaving oddly

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

    Can an active page be deactivated?

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

    Set page break with VBA?

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

    break concatenate

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

    Break line

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

    Ctrl Break Mode Stuck

    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?
  18. D

    Breaking a link

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

    Breaking down ranges into individual rows.

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

    Lifetime and Scope of variables

    I am a bit confused with regard to the Lifetime and Scope of variables. Given this code: Option Explicit Dim a As Integer Sub FromSheet1() Sheet3.Select a = 1 End Sub Sub FromSheet2() Sheet3.Select a = 2 End Sub Sub GoBack() If a...

Some videos you may like

This Week's Hot Topics

Top