1. A

    Copy Microsoft Word table cell content including line breaks into Excel cell via VBA

    Hi all, I have the below VBA code that will copy the contents of a Microsoft Word table cell and paste it into an Excel cell. Cells(x) = WorksheetFunction.Clean(.Cell(x).Range.Text) It works apart from picking up line breaks. So if the Word table cell reads Username: CH_CLERICAL1 Password...
  2. A

    Line breaks in text boxes linked to cell

    Hi everyone, I was wondering whether it's possible to insert line breaks into a text box's text linked via formula to a cell. For example, Cell A1: "Hello, pleased to meet you. I'd like to buy an apple" text box: =A1 -> text box displays the following with no line breaks [ Hello, pleased to...
  3. P

    Conditional Format STOPS at linefeed (line feed, line break)

    In 2003 Conditional Format would format (font) the whole cell. It appears that 2010 stops the formatting after a linefeed? Is this right? ie. is it my configuration/system? Is it configurable? Is there a workaround? Thanks very much.
  4. J

    Find/Replace Alt + 0010 for Mac

    Hi, On a PC, in the Find/Replace menu, I can add line breaks using Alt + 0010 or Ctrl + J on a laptop. What is the equivalent on a Mac? Option + 0010, Option + 0013, Apple key + 0010, Apple key + 0013 all don't seem to work. Thanks, Josh

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...