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, 10 months ago 6 Members · 8 Replies
  • 8 Replies
  • Vince

    Member
    July 6, 2022 at 2:22 pm
    Points: 13,660
    Rank: UC2 Brainery Blue Belt III UC2 Brainery Blue Belt III

    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,323
      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

        Member
        July 6, 2022 at 2:39 pm
        Points: 13,660
        Rank: UC2 Brainery Blue Belt III UC2 Brainery Blue Belt III

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

  • David Cutler

    Member
    July 6, 2022 at 3:45 pm
    Points: 26,616
    Rank: UC2 Brainery Advanced Brown Belt UC2 Brainery Advanced Advanced Brown Belt Rank

    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: 15,067
      Rank: UC2 Brainery Advanced Blue Belt UC2 Brainery Advanced Blue Belt Rank

      Try the Export to Word function.

      Might work better

  • Vince

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

    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: 23,637
    Rank: UC2 Brainery Brown Belt III UC2 Brainery Brown 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?…

Log in to reply.