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?

    Troy DeGroot replied 5 months ago 4 Members · 6 Replies
  • 6 Replies
  • Vince

    Member
    July 6, 2022 at 2:22 pm
    Points: 6,576
    Rank: UC2 Brainery Purple Belt I UC2 Brainery Purple 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: 1,780
      Rank: UC2 Brainery Yellow Belt II UC2 Brainery Yellow Belt II

      Awesome thank you.

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

      • Vince

        Member
        July 6, 2022 at 2:39 pm
        Points: 6,576
        Rank: UC2 Brainery Purple Belt I UC2 Brainery Purple Belt I

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

  • David Cutler

    Member
    July 6, 2022 at 3:45 pm
    Points: 13,169
    Rank: UC2 Brainery Blue Belt III UC2 Brainery Blue Belt III

    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…

  • Vince

    Member
    July 6, 2022 at 3:58 pm
    Points: 6,576
    Rank: UC2 Brainery Purple Belt I UC2 Brainery Purple 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?

  • Troy DeGroot

    Organizer
    July 7, 2022 at 2:02 pm
    Points: 13,820
    Rank: UC2 Brainery Blue Belt III UC2 Brainery Blue Belt III

    @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?…