Copying Text from Bluebeam

  • Copying Text from Bluebeam

    Posted by Matt Hackman on July 6, 2022 at 2:05 pm

    When copying text from Bluebeam that has multiple lines and pasting somewhere else, the paste will keep the line returns precisely as shown in Bluebeam and I will need to delete the return and add a space to get the text formatted into my excel/word file. Is there a tip/fix for this?

    Doug McLean replied 1 year ago 6 Members · 8 Replies
  • 8 Replies
  • Vince French

    Member
    July 6, 2022 at 2:22 pm
    Points: 11,498
    Rank: UC2 Brainery Blue Belt I UC2 Brainery Blue Belt I

    If you paste into Excel you can then use the ‘Textjoin’ function to create a single line then delete the original text e.g. if you have copied & pasted from Bluebeam and you have text in cells A1 to A9 then use

    =TEXTJOIN(” “,,A1:A9)

    • Matt Hackman

      Member
      July 6, 2022 at 2:35 pm
      Points: 2,250
      Rank: UC2 Brainery Yellow Belt IIII UC2 Brainery Yellow Belt IIII

      Awesome thank you.

      What about if I pasted it all into a single cell and it retains all the returns?

      • Vince French

        Member
        July 6, 2022 at 2:39 pm
        Points: 11,498
        Rank: UC2 Brainery Blue Belt I UC2 Brainery Blue Belt I

        Try =SUBSTITUTE(A1,CHAR(10), ” “)

  • David Cutler

    Member
    July 6, 2022 at 3:45 pm
    Points: 22,403
    Rank: UC2 Brainery Brown Belt II UC2 Brainery Brown Belt II

    I’ve had good luck saving PDFs as Word documents and then copying the text I need from there. I can’t say that I’ve ever tried it with a drawing though…

    • Doug McLean

      Member
      February 16, 2023 at 10:12 pm
      Points: 11,785
      Rank: UC2 Brainery Blue Belt I UC2 Brainery Blue Belt I

      Try the Export to Word function.

      Might work better

  • Vince French

    Member
    July 6, 2022 at 3:58 pm
    Points: 11,498
    Rank: UC2 Brainery Blue Belt I UC2 Brainery Blue Belt I

    There is also supposed to be another method in Excel using the ‘Find and Replace’ function.

    Apparently in the find box you press ctrl + j the. In the replace box you put a space.

    I’ve managed to get this to work a couple of times but most of the time I get an error message.

    I’m not sure if there is a similar function in Word?

    • Paul Kuehnel

      Member
      February 15, 2023 at 8:32 pm
      Points: 209
      Rank: UC2 Brainery Newbie UC2 Brainery Newbie Belt Rank

      In word, select the text you have pasted > click ctrl+H (find and replace) > click the “more” button > place your cursor in the find field > click “special” at the bottom of the window > paragraph mark > leave the replace field blank > click replace all.

      This will find all the paragraph marks in your selected text and delete them (replace them with nothing).

  • Troy DeGroot

    Organizer
    July 7, 2022 at 2:02 pm
    Points: 20,343
    Rank: UC2 Brainery Brown Belt UC2 Brainery Advanced Brown Belt Rank

    @matt-hackman Have you tried the export to Excel or Word functions under the File menu? You can draw a region around a drawing schedule and export it directly to Excel. Maybe this would help?…

Log in to reply.